How to map table splitting in EF Code First?

by

Here is how I just got EF 4.1 (RC) to do table splitting in Code First.

  1. Define your two entities. Make sure to include the key in both entities. Also, include navigation properties in each entity pointing to the other entity.

  2. In your OnModelCreating override . . .
    a. Map both entities to the same table.
    b. Create the relationship between the two tables.

        modelBuilder.Entity<EntityOne>().ToTable("MySingleTable");
    modelBuilder.Entity<EntityTwo>().ToTable("MySingleTable");

    modelBuilder.Entity<EntityOne>().HasRequired(p => p.NavToEntityTwo).WithRequiredDependent(c => c.NavToEntityOne);

This is working for me, but realize that given the newness of the RC I’ve only been able to look at limited and simple scenarios.

More Related Contents:

  1. Model First with DbContext, Fails to initialize new DataBase
  2. Getting exact error type in from DbValidationException
  3. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  4. Code-first vs Model/Database-first [closed]
  5. Ignoring a class property in Entity Framework 4.1 Code First
  6. Using Entity Framework (code first) migrations in production
  7. Generate POCO classes in different project to the project with Entity Framework model
  8. How to set default value for POCO’s in EF CF?
  9. Organizationally, where should I put common queries when using Entity Framework Code First?
  10. How to store images using Entity Framework Code First CTP 5?
  11. Foreign keys in entity framework 4.1
  12. LINQ to Entities does not recognize the method
  13. How can I query for null values in entity framework?
  14. Get Database Table Name from Entity Framework MetaData
  15. Undo changes in entity framework entities
  16. Update primary key value using entity framework
  17. ASP.NET MVC: Is Controller created for every request?
  18. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  19. EF LINQ include multiple and nested entities
  20. EF Code First – how to set identity seed?
  21. How to work with Enums in Entity Framework?
  22. instance of entity type cannot be tracked because another instance with same key value is tracked [closed]
  23. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  24. How to Specify Primary Key Name in EF-Code-First
  25. Entity Framework: Duplicate Records in Many-to-Many relationship
  26. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  27. Entity Framework Find vs. Where
  28. ‘ObjectContext’ vs ‘DbContext’ in Entity Framework
  29. Using Entity Framework entities as business objects?
  30. How can set a default value constraint with Entity Framework 6 Code First?

Leave a Comment