entity-framework-4.1 multiple-tables ef4-code-only

How to add entity to multiple tables?

I have 2 tables in my DB: Students and StudentsHistory. The idea is that every change in the Students table must create a new record in the StudentsHistory table (e.g. when I edit a student, 2 operations must be performed: UPDATE on Students and INSERT on StudentsHistory).

How can I do this with Entity Framework 4.1 Code-First without creating 2 classes and having them mapped? I want to have only Student class and somehow tell EF to save the Student object to 2 tables.

Anyone can help?

PS It should be done in code, not using SQL triggers or something.

Solution

Like Ladislav said, you cannot map 2 tables to one entity. You may want to think about creating an audit for student history.

Is DbContext thread safe?
Entity Framework code first. Find primary key
in entity framework code first, how to use KeyAttribute on multiple columns
Entity Framework Code-First: How to manually update the database?
What is the difference between IDbSet.Add and DbEntityEntry.State = EntityState.Added?
Entity Framework Validation confusion - maximum string length of '128'
The type or namespace name 'Entity' does not exist in the namespace 'System.Data'
Entity framework code first convert between class boolean and column integer
Entity Framework - How to check if table exists?
How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
Entity framework code-first null foreign key
The relationship could not be changed because one or more of the foreign-key properties is non-nullable
Top per group: Take(1) works but FirstOrDefault() doesn't?
Better way to query a page of data and get total count in entity framework 4.1?
Entity framework strings using greater than operator
Multiple DbContexts in N-Tier Application
Can you get the DbContext from a DbSet?
EF Code First DBContext and Transactions
Writing LINQ queries. Joins VS navigational properties
EF - Cascade Delete Not Working, Can't Delete Object
Validation failed for one or more entities. See 'EntityValidationErrors' property for more details
FirstOrDefault throws 'Sequence contains more than one matching element'
Self referencing / parent-child relationship in Entity Framework
How to update not every fields of an object using Entity Framework and EntityState.Modified
Entity Framework - Is there a way to automatically eager-load child entities without Include()?
Entity Framework 4.1 and BLOBs
Getting exact error type in from DbValidationException
An error occurred while saving entities that do not expose foreign key properties for their relationships
DbSet table name
Update a single property of a record in Entity Framework Code First