mapping multiple tables to a single entity class in entity framework

Question

I am working on a legacy database that has 2 tables that have a 1:1 relationship. Currently, I have one type (1Test:1Result) for each of these tables defined I would like to merge these particular tables into a single class.

The current types look like this

public class Result 
{
    public          string      Id                  { get; set; }
    public          string      Name                { get; set; }
    public          string      Text                { get; set; }
    public          string      Units               { get; set; }
    public          bool        OutOfRange          { get; set; }
    public          string      Status              { get; set; }
    public          string      Minimum             { get; set; }
    public          string      Maximum             { get; set; }

    public virtual  Instrument  InstrumentUsed      { get; set; }

    public virtual  Test        ForTest             { get; set; }
}


public class Test
{
    public          int     Id            { get; set; }
    public          string  Status        { get; set; }
    public          string  Analysis      { get; set; }
    public          string  ComponentList { get; set; }
    public virtual  Sample  ForSample     { get; set; }
    public virtual  Result  TestResult    { get; set; }
}

I would prefer them to look like this

public class TestResult
{
    public          int        Id              { get; set; }
    public          string     Status          { get; set; }
    public          string     Analysis        { get; set; }
    public          string     ComponentList   { get; set; }
    public          string     TestName        { get; set; }
    public          string     Text            { get; set; }
    public          string     Units           { get; set; }
    public          bool       OutOfRange      { get; set; }
    public          string     Status          { get; set; }
    public          string     Minimum         { get; set; }
    public          string     Maximum         { get; set; }

    public virtual  Instrument InstrumentUsed { get; set; }
}

I am currently using the fluent API for mapping these to our legacy Oracle database.

What would be the best method of combining these into a single class? Please note that this is a legacy database. Changing the tables is not an option and creating views is not a viable solution at this point in the project.

Eranga · Accepted Answer · 2011-07-13 00:21:06Z

44

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

answered Jul 13, 2011 at 0:21

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Chris McGrath Over a year ago

they do have the same key so this should work in the event they didnt would it still be possible by mapping relationship seperately or is that not available in this version of the framework yet ?

roland Over a year ago

How would you map to Instrument?

Karthic G Over a year ago

What is the equivalent of Map() in EF Core

Dai Over a year ago

@KarthicG There isn't one. EF Core 6 still doesn't support mapping multiple tables to a single entity - but if you use database-first (instead of code-first) then you could use a VIEW to join the tables together and lie to EF Core and pinky-swear that the VIEW is really a TABLE - which is perfectly valid as you can define INSERT and UPDATE handlers for VIEW objects in SQL Server.

n0099 Over a year ago

They've made it in EF Core 7: github.com/dotnet/efcore/issues/620 learn.microsoft.com/en-us/ef/core/modeling/…

Collectives™ on Stack Overflow

mapping multiple tables to a single entity class in entity framework

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related