Inheritance with the Entity Framework Code first, field repeats in table

Question

Class GeneralRequest 
{    
String BaseProperty { get set}
}

RapidRequest: GeneralRequest
{
Bool IsSignRequired { get set}    
}

BackRequest : GeneralRequest
{
Bool IsSignRequired { get set}    
}

OtherRequest: GeneralRequest
{   
String Note   { get set}   
}

This is the structure of codes I have in my project.

The property IsSignRequired comes in BackRequest and RapidRequest but it need not come in OtherRequest.

But when I generate database using this codes.

I get property IsSignRequired comes twice in my table as IsSignRequired1 IsSignRequired2 etc.

How can I specify that it is only neded once in my table

Where is the OtherRequest property in your model? I see the OtherRequest class only. — romanoza
– romanoza, Commented May 13, 2015 at 15:01
it is IsSignRequired proprty.Let me edit the post thanks roman — Kuttan Sujith
– Kuttan Sujith, Commented May 14, 2015 at 13:30

Bradley Uffner · Accepted Answer · 2015-05-13 13:42:06Z

1

You either need to have another intermediate class that RapidRequest and BackRequest inherits from that defines an inherited IsSignRequired, or use the ColumnAttribute to force the name of the field. Another option is to use TablePerType inheritance, but that will generate separate tables for unique fields for each subclass.

EntityFramework is doing this because the field is declared independently on the subclasses. By default each subclass will get unique copies of any fields defined in that class, only inherited fields will be shared.

answered May 13, 2015 at 13:42

Bradley Uffner

17.1k4 gold badges43 silver badges80 bronze badges

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

Collectives™ on Stack Overflow

Inheritance with the Entity Framework Code first, field repeats in table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related