Over a million developers have joined DZone.

Entity Framework Code First and Inheritance

DZone's Guide to

Entity Framework Code First and Inheritance

· Java Zone
Free Resource

What every Java engineer should know about microservices: Reactive Microservices Architecture.  Brought to you in partnership with Lightbend.

Recently I am using Entity Framework a lot. So I tried some advanced scenarios, and this post is related to it only. In this post we will learn how entity framework handles inheritance.

In the object oriented world, We all use Inheritance for reusability. We create some base classes and inherit those in child classes to facilitate code reuse and we don’t have to write again and again. In this post we will also have same kind of methodology. We are going to create a “Person” class and inherit this in to Employee and Customer class and we are going to see how entity framework code first handles this kind of inheritance by default. I’m going to use entity framework version 6.0 and Visual Studio 2013.

So what we are waiting for. Let’s get started. So create a console application from file menu new project.


Once you are done with creating a application. It’s time to add entity framework via nuget package.


Now we’re done with adding a nuget package it’s time to write classed that we have decided. Following a code for Person class.

public class Person
    public int Id { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }

Now we are going to create a Employee class which will be inherited from the Person class and have some onw properties.

public class Employee :Person
    public string Designation { get; set; }

Same way following is a code for Customer Class.

public class Customer: Person
    public string PhoneNumber { get; set; }

Now it’s time to add a database.


Now I’ve added connection string in my app config file like following.

  <add connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\data\Blog\Samples\EntityInheritance\EntityInheritance\EntityInheritance.mdf;Integrated Security=True" name="MyConnectionString" providerName="System.Data.SqlClient"/>

Now it’s time to write a code for database context file. Following is a code for that.

public class EDataContext : DbContext
    public EDataContext() : base("MyConnectionString")
    public IDbSet<Customer> Customers { get; set; }
    public IDbSet<Employee> Employees { get; set; }

Here you can see it’s very simple. There are two dbset properties for Employee and Customer. Now in my main I have written following code to list employee.

static void Main(string[] args)
    using (var context = new EDataContext())
        var employees = context.Employees.ToList();
        foreach (Employee employee in employees)

Now let’s run this application. Right now it will do nothing as we don’t have any data inserted in it. But let’s take a look of database and see what happened there.


Here you can see that it has created two tables for both entities so this called “Table Per Type” inheritance where it created a two tables for each type Customer and Employee. In future post we will see “Table per hierarchy” inheritance where we will have a single table for Customers and Employees.

Hope you like it. Stay tuned for more!

Microservices for Java, explained. Revitalize your legacy systems (and your career) with Reactive Microservices Architecture, a free O'Reilly book. Brought to you in partnership with Lightbend.


Published at DZone with permission of Jalpesh Vadgama, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}