How to map Table per Type (TPT) inheritance in Entity designer?

by

Yes that is how Entity designer behaves. If you model your structure in the database and use Update model from database it will indeed be modeled as common associations beacuse EF doesn’t know yet that you want to model it as inheritance. You will get this:

enter image description here

You must manually modify this model to use TPT inheritance. First delete both relations. It will also remove navigation properties and you will get this:

enter image description here

Use Inheritance from toolbox (as described on previous screenshot) and draw a line from Film to Item and from Game to Item. Now you need to finish this model. The current model will not validate because ItemId is mapped in both parent and child entity. Delete ItemId from both Film and Game entities. You can also make Item entity Abstract and you will get this:

enter image description here

More Related Contents:

  1. How do I view the SQL generated by the Entity Framework?
  2. how to update an entity in Entity Framework 4 .NET
  3. Entity Framework 4 selective lazy loading properties
  4. ADO.NET Entity Framework tutorials [closed]
  5. Delete an object and all of its related entities in Entity Framework
  6. EF Core Second level ThenInclude missworks
  7. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  8. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  9. Best way to check if object exists in Entity Framework? [closed]
  10. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  11. EF5 Code First Enums and Lookup Tables
  12. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  13. Entity Framework One-To-One Mapping Issues
  14. Is it possible to run native sql with entity framework?
  15. How can I delete 1,000 rows with EF6?
  16. When should I call SaveChanges() when creating 1000’s of Entity Framework objects? (like during an import)
  17. Adding Validation Attributes With an Entity Framework Data Model
  18. How to exclude one table from automatic code first migrations in the Entity Framework?
  19. Ramifications of DbSet.Create versus new Entity()
  20. Entity Framework : How do you refresh the model when the db changes?
  21. Entity framework code first creates “discriminator” column
  22. EF Migrations: Rollback last applied migration?
  23. Using EF Core ThenInclude() on Junction tables
  24. How to update not every fields of an object using Entity Framework and EntityState.Modified
  25. What is the best practice in EF Core for using parallel async calls with an Injected DbContext?
  26. Entity Framework v2 doesn’t support sql 2000?
  27. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]
  28. Entity Framework: Inheritance and Include
  29. Entity Framework – Get List of Tables
  30. Entity framework code first delete with cascade

Leave a Comment