Click here to Skip to main content
Click here to Skip to main content

EF Feature CTP5: Inheritance Scenarios with Code First Fluent API

, 12 Dec 2010
Rate this:
Please Sign up or sign in to vote.
EF Feature CTP5: Inheritance Scenarios with Code First Fluent API

Introduction

One of the interesting features of Code First fluent API is the ability EF Feature CTP5: Inheritance Scenarios with Code First Fluent APIto configure inheritance in your model. Since one of the strengths of an O/RM solution is its ability to map inheritance, this feature is a must in every mapping scenario (may it be Model first, Database First or Code First). In this post, I'll show how to configure inheritance by using the fluent API.

Revisiting Entity Framework Inheritance Types

In the past, I wrote a series of posts about inheritance mapping in Entity Framework which you can read here:

Configure Inheritance Using Code First Fluent API

In the previous CTPs, in order to create inheritance we had to use the MapHierarchy method which was very tedious. In this version, the MapHierarchy method was replaced by the Map method (and not in all the inheritance mapping scenarios you'll need to use it). Let's explore the inheritance types:

Table Per Type (TPT) Inheritance

In order to create this type of mapping, all you have to do is to use the ToTable method:

public class Course
{
  #region Properties
 
  public int CourseID { get; set; }
  public string Title { get; set; }
  public string Days { get; set; }
  public DateTime Time { get; set; }
  public string Location { get; set; }
  public int Credits { get; set; }    
 
  #endregion
}
 
public class OnLineCourse : Course
{
  #region Properties
 
  public string CourseURL { get; set; }
 
  #endregion
}
 
public class SchoolEntities : DbContext
{
  #region Properties
 
  public DbSet<Course> Courses { get; set; }
 
  #endregion
 
  #region Methods
 
  protected override void OnModelCreating(ModelBuilder modelBuilder)
  {
    modelBuilder.Entity<Course>()
      .ToTable("Courses");
 
    modelBuilder.Entity<OnLineCourse>()
     .ToTable("OnLineCourses");
  }
 
  #endregion
}

You start with creating the inheritance in the model itself (OnLineCourse inherits from Course) and then in the DbContext’s OnModelCreating method, you specify that every type will be mapped to its own table using the ToTable method.

Table Per Hierarchy (TPH) Inheritance

In order to create this type of mapping, you need to use the Map method. In the lambda, the Map method gets you write the discriminator field and its values using the Requires and HasValue methods. In the following example, you can see how to do exactly that:

public class Course
{
  #region Properties
 
  public int CourseID { get; set; }
  public string Title { get; set; }
  public string Days { get; set; }
  public DateTime Time { get; set; }
  public string Location { get; set; }
  public int Credits { get; set; }    
 
  #endregion
}
 
public class OnLineCourse : Course
{
  #region Properties
 
  public string CourseURL { get; set; }
 
  #endregion
}
 
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
  modelBuilder.Entity<Course>()
    .Map(c =>
    {
      c.Requires("Discriminator").HasValue(1);
    })
    .Map<OnLineCourse>(olc =>
    {
      olc.Requires("Discriminator").HasValue(2);
    });
}

Table Per Concrete Type (TPC) Inheritance

In order to create this type of mapping, you will start as it is a table per type inheritance configuration. The only change is the use of the Map method on the concrete type. In the method lambda, you will use the MapInheritedProperties method to indicate it is a concrete type:

public class Course
{
  #region Properties
 
  public int CourseID { get; set; }
  public string Title { get; set; }
  public string Days { get; set; }
  public DateTime Time { get; set; }
  public string Location { get; set; }
  public int Credits { get; set; }    
 
  #endregion
}
 
public class OnLineCourse : Course
{
  #region Properties
 
  public string CourseURL { get; set; }
 
  #endregion
}
 
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
  modelBuilder.Entity<Course>()
    .ToTable("Courses");
 
  modelBuilder.Entity<OnLineCourse>()
   .Map(olc =>
   {
     olc.MapInheritedProperties();
   }).ToTable("OnLineCourses");
}

Here is a simple check to see how the database is created in each inheritance type:

using (SchoolEntities context = new SchoolEntities())
{
  context.Database.Delete();
  var course = new Course
  {          
    Credits = 2,
    Days = "MF",
    Location = "Class 1",
    Time = DateTime.Now,
    Title = "Entity Framework",
  };
  var onLineCourse = new OnLineCourse
  {          
    Credits = 3,
    Days = "WT",
    Location = "Class 2",
    Time = DateTime.Now,
    Title = "Entity Framework On Line",
    CourseURL = "http://www.gilfink.net",
  };
  context.Courses.Add(course);
  context.Courses.Add(onLineCourse);
  context.SaveChanges();

Pay attention that in the TPC inheritance, the database will be created properly and the insert will succeed but there will be an exception of overlapping keys (both courses will be created with CourseID of 1 and in the context there will be overlapping).

Summary

Using the Code First fluent API for inheritance is easy. In the post, I showed how you can do that using the three main inheritance scenarios in Entity Framework.


License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Gil Fink
Architect Sela Group
Israel Israel
Gil Fink is an expert in web development and Microsoft web and data platforms. He works as a senior consultant and architect at Sela Group. He is currently consulting for various enterprises and companies, where he helps to develop Web and RIA-based solutions. He conducts lectures and workshops for individuals and enterprises who want to specialize in infrastructure and web development. He is also a co-author of several Microsoft Official Courses and training kits and the founder of Front-End.IL meetup. You can read his publications at his website: http://www.gilfink.net
Follow on   Twitter   Google+

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web02 | 2.8.140718.1 | Last Updated 12 Dec 2010
Article Copyright 2010 by Gil Fink
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid