Part 11 Entity splitting in entity framework with code first approach

Text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-11-entity-splitting-in-entity.html

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1

Slides
http://csharp-video-tutorials.blogspot.com/2014/05/part-11-entity-splitting-in-entity_21.html

Entity Framework - All Text Articles
http://csharp-video-tutorials.blogspot.com/2014/05/entity-framework-tutorial.html

Entity Framework - All Slides
http://csharp-video-tutorials.blogspot.com/2014/05/entity-framework-tutorial-slides.html

Entity Framework Playlist
https://www.youtube.com/playlist?list=PL6n9fhu94yhUPBSX-E2aJCnCR3-_6zBZx

Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd


Entity splitting refers to mapping an entity to two or more tables when the tables share a common key. We discussed, Entity splitting with database first approach in Part 10

By default, Entity Framework code-first creates one Employees table based on Employee class

To map the Employee entity to 2 tables -- Employees & EmployeeContactDetails, override OnModelCreating() method of the DBContext class

public class EmployeeDBContext : DbContext
{
public DbSet[Employee] Employees { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity[Employee]()
// Specify properties to map to Employees table
.Map(map =]
{
map.Properties(p =] new
{
p.EmployeeId,
p.FirstName,
p.LastName,
p.Gender
});

map.ToTable("Employees");
})
// Specify properties to map to EmployeeContactDetails table
.Map(map =]
{
map.Properties(p =] new
{
p.EmployeeId,
p.Email,
p.Mobile,
p.Landline
});

map.ToTable("EmployeeContactDetails");
});

base.OnModelCreating(modelBuilder);
}
}