Entity Framework 6 Creating Two table from the same entity object

Question

I was wondering if it's possible to create two table instance from one defined entity object class.

Example:

public class EntityA()
{
    public String name {get; set;}
    public String value {get; set;}
}

public class MyDbConext : DbContext
{
    public DbSet<EntityA> instance1{ get; set; }
    public DbSet<EntityA> instance2{ get; set; }
}

What i'm trying to do is create two instances of Entity A with different table names. Is that possible with code first entity framework? I feel like it's seems tedious to have to just create another class that extends entity EntityA to just create another instance of the same entity.

Desired Output:

Creation of "Instance1_Table" from EntityA class
Creation of "Instance2_Table" from EntityA class

The code in the DBConext will throw an exception.

Any advice appreciated, Thanks, D

DDan · Accepted Answer · 2015-08-11 07:29:07Z

6

You cannot have multiple DbSet pointing to the same class in one DbContext. Your options are:

Creating new class with same properties
Inheritance
Using different DBContexts

answered Aug 11, 2015 at 7:29

DDan

8,3566 gold badges38 silver badges65 bronze badges

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

1 Comment

Squirrel in training Over a year ago

do youz have any idea why they made this design choice? It makes no sense in my eyes, especially if you can circumvent this by just adding once extra layer of inheritance..

Collectives™ on Stack Overflow

Entity Framework 6 Creating Two table from the same entity object

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related