Map two different entities to the same table?

by

You can’t map two regular entities into same table. You have several choices:

  1. Use table splitting.
  2. Use custom query with projection to non entity type (as @Aducci proposed)
  3. Use QueryView
  4. Use database view or directly DefiningQuery

Table splitting

Table splitting allows you to map a table into two entities in 1:1 relation. First entity will contain only PK and subset of fields which you need always. Second entity will contain all other fields and PK. Both entities will contain navigation property to each other. Now if you need only subset of fields you will query first entity. If you need all fields you will query first entity and include navifation property to second entity. You can also lazy load second entity if you need it.

QueryView

QueryView is ESQL query defined directly in your mapping (MSL) and it is mapped to new readonly entity type. You can use QueryView to define projection of your full entity into subentity. QueryView must be defined manually in EDMX (it is not available in designer). As I know QueryView is not available in Code first but it is actually the same as custom projection to non entity type.

DefiningQuery

DefiningQuery is custom query defined directly in your storage model (SSDL). DefiningQuery is usually used when mapping to database views but you can use it for any custom SQL SELECT. You will map the result of the query to readonly entity type. DefiningQuery must be defined manually in EDMX (it is not available in designer). It is also not directly avaliable in Code first but it is actually the same as calling SqlQuery on DbDatabase. The problem with DefiningQuery is that once you manually define it in SSDL you can’t use Update model from database because this operation replaces complete SSDL and deletes your query definition.

More Related Contents:

  1. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  2. Disable lazy loading by default in Entity Framework 4
  3. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  4. How to include a child object’s child object in Entity Framework 5
  5. Entity Framework 4 / POCO – Where to start? [closed]
  6. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  7. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  8. Unique keys in Entity Framework 4
  9. Entity Framework 4 selective lazy loading properties
  10. Upgrade EF 4 EDMX to EF 6
  11. Querying objects after AddObject before SaveChanges?
  12. EF Migrations: Rollback last applied migration?
  13. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  14. Using Entity Framework with an SQL Compact Private Installation
  15. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  16. AutomaticMigrationsEnabled false or true?
  17. Compose queries across Entity Data Models
  18. Changing Inherited Types in Entity Framework
  19. How do I use structural annotations to set SQL type to Date in model first approach
  20. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  21. Solution for “Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details.”
  22. How do you update an edmx file with database changes?
  23. Cascading deletes with Entity Framework – Related entities deleted by EF
  24. How do I singularize my tables in EF Code First?
  25. Entity Framework and calling context.dispose()
  26. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  27. Error 6002: The table/view does not have a primary key defined
  28. int to string in Entity Framework
  29. Entity Framework Core 2.0 – Run migrations step by step
  30. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())

Leave a Comment