Can I specify global mapping rules in Entity Framework Code First?

by

Such a mapping – called Table-Per-Concrete-Type (TPC) inheritance mapping – only makes sense if you really want to leverage polymorphism, for example if you want to load a list of say 10 BaseEntity objects and expect that the actual type gets materialized so that the list contains 3 User entities and 7 Product entities.

Would such a query ever have any business relevance in your application? Looking at your BaseEntity I can only see that querying all objects that – for example – have been created at a specific date, no matter which type the object has (if it’s derived from BaseEntity), could be useful. Do you need that? Also keep in mind how complex such a query would be. The SQL must query for almost all tables in your database and then union the result.

I would use inheritance mapping only if it has a real business meaning (for instance: Person which has meaningful properties like address, phone, email, etc. on its own and Employee that is derived from Person and adds a Salary and HiredDate property, etc.).

In your case I would use the BaseEntity only as a base type of your entity classes and don’t specify any mapping at all for this class. EF will still map the inherited properties, but as part of the User and Product entity, etc., not as its own entity. I wouldn’t even call it “Base Entity” but … I don’t know… maybe EntityBase (meaning: the base (class) of all entities, but not an entity itself).

More Related Contents:

  1. Convert value when mapping
  2. Adding Validation Attributes With an Entity Framework Data Model
  3. How do I view the SQL generated by the Entity Framework?
  4. EF Core Second level ThenInclude missworks
  5. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  6. Disable lazy loading by default in Entity Framework 4
  7. Best way to check if object exists in Entity Framework? [closed]
  8. No connection string named ‘MyEntities’ could be found in the application config file
  9. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  10. How to include a child object’s child object in Entity Framework 5
  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. Entity framework code-first null foreign key
  15. Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)
  16. Entity Framework CTP 4 – Code First Custom Database Initializer
  17. Multi-async in Entity Framework 6?
  18. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  19. Efficient way to do bulk insert/update with Entity Framework
  20. ef core 2 apply HasQueryFilter for all entity
  21. Value cannot be null. Parameter name: entitySet
  22. SQL Server Express connection string for Entity Framework Code First
  23. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  24. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  25. EF Code First DBContext and Transactions
  26. How can I disable migration in Entity Framework 6.0
  27. How do I use Entity Framework in Code First Drop-Create mode?
  28. Many to Many Relationships not saving
  29. DbContext AutoDetectChangesEnabled set to false detecting changes
  30. .NET 4.5 Beta DbGeography NotImplementedException

Leave a Comment