Entity Framework DB-First, implement inheritance

by

One possible way is to use one table for each type called TPT (table-per-type), which I prefer to use. To achieve this, you define your tables like the model shown in the following picture:

table hierarchy

Note that the relationships between child and base entity are one-to-one on their pk columns, and all common fields are moved to the base table. After creating your tables, right click on the models page in your visual studio, and select Update Model from Database…, and then in the add tab, select these 3 tables to add. At first you should see this model diagram, which needs to be changed a bit:

tables added at first

Do these steps for Person and Organization separately:

  • Right click on entity and select Properties
  • In the Base Type property select Identity
  • Select and then delete the association between this entity and Identity
  • Select and then Delete the PK (ID column) of this entity (Inherits from base entity)

After these steps save your model. Now your model should look like this:

the changed model

Now compile your project and enjoy your life!

Additional resources:
Entity Framework Designer TPH Inheritance

More Related Contents:

  1. How to update record using Entity Framework 6?
  2. C# Error: Parent does not contain a constructor that takes 0 arguments
  3. Entity Framework Core: A second operation started on this context before a previous operation completed
  4. LINQ To Entities does not recognize the method Last. Really?
  5. Bulk-deleting in LINQ to Entities
  6. Entity Framework And Business Objects
  7. Self referencing loop detected – Getting back data from WebApi to the browser
  8. C# – Making all derived classes call the base class constructor
  9. What’s the difference between using the Serializable attribute & implementing ISerializable?
  10. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  11. Entity vs Model vs View Model
  12. How to check if a class inherits another class without instantiating it? [duplicate]
  13. Using Simple Injector with Unit Of Work & Repository Pattern in Windows Form
  14. Entity Framework: How to disable lazy loading for specific query?
  15. Finding the reason for DBUpdateException
  16. The entity type ApplicationUser is not part of the model for the current context
  17. GUID COMB strategy in EF
  18. Max return value if empty query
  19. Group by with multiple columns using lambda
  20. Keyword Not Supported: Metadata
  21. Check if list contains item from other list in EntityFramework
  22. Entity Framework Code First: How can I create a One-to-Many AND a One-to-One relationship between two tables?
  23. Entity Framework: Duplicate Records in Many-to-Many relationship
  24. Mixing Fluent API and DataAnnotations in EF code first
  25. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  26. Register AspNetCore 2.1 Identity system with DbContext interface
  27. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  28. Entity framework – get entity by name
  29. Watch for a table new records in sql database
  30. LINQ Query to Convert string to datetime

Leave a Comment