mapping multiple tables to a single entity class in entity framework

by

You can use Entity Splitting to achieve this if you have the same primary key in both tables.

  modelBuilder.Entity<TestResult>()
    .Map(m =>
      {
        m.Properties(t => new { t.Name, t.Text, t.Units /*other props*/ });
        m.ToTable("Result");
      })
    .Map(m =>
      {
        m.Properties(t => new { t.Status, t.Analysis /*other props*/});
        m.ToTable("Test");
      });

Here’s a useful article

More Related Contents:

  1. Better way to query a page of data and get total count in entity framework 4.1?
  2. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  3. Entity Framework Code First – two Foreign Keys from same table
  4. Ignoring a class property in Entity Framework 4.1 Code First
  5. Entity Framework Join 3 Tables
  6. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  7. Why Interface Layer/Abstract classes required in our project? [closed]
  8. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  9. EF 4.1 – Code First – JSON Circular Reference Serialization Error
  10. EF Code First: How to get random rows
  11. Non-static method requires a target
  12. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  13. Navigation Property without Declaring Foreign Key
  14. Place to put Database.SetInitializer
  15. Serializable classes and dynamic proxies in EF – how?
  16. An error occurred while saving entities that do not expose foreign key properties for their relationships
  17. Can you get the DbContext from a DbSet?
  18. Entity Framework Code First Date field creation
  19. Entity Framework – how do I get the columns?
  20. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  21. System.Data.MetadataException: Unable to load the specified metadata resource
  22. Entity Framework: field of composite key cannot be nullable?
  23. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  24. SqlException from Entity Framework – New transaction is not allowed because there are other threads running in the session
  25. How to filter “Include” entities in entity framework?
  26. When should one use dynamic keyword in c# 4.0?
  27. Check if list contains any of another list
  28. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  29. Model Binding to Enums in ASP.NET MVC 3
  30. Use both AddDbContextFactory() and AddDbContext() extension methods in the same project

Leave a Comment