Entity Framework Code First with TPT Inheritance and Composite Keys

Question

I have a requirement to build a slightly unusual data model, but I'm having trouble persuading Entity Framework Code First to map it for me.

I have two entities - 'A' and 'B'.

'B' is a type of 'A', which is why I'm trying to get inheritance working.

However, multiple versions of 'B' may exist.

I would like to model this by having a shared ID column in each of the tables for 'A' and 'B', but for 'B' to also have a 'Version Number' field which makes a combined key with the ID.

So - this would be a one-to-many inheritance type of arrangement.

Ultimately the goal for this would be to be able to retrieve a specific 'B' entity and for it to also contain all of the properties and methods of the related 'A' entity without having to go via another object.

Any ideas would be great.

Thanks, Chris

Ladislav Mrnka · Accepted Answer · 2012-05-30 09:12:08Z

1

Inheritance in EF is always one-to-one. If you have one-to-many you must handle it as relation or build your own intermediate layer which will hide EF implementation by your own domain model (which will take related objects from EF and create your own inherited object).

answered May 30, 2012 at 9:12

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

1 Comment

Chris Roberts Over a year ago

I suspected that may be the case - thanks for confirming!! :o)

Collectives™ on Stack Overflow

Entity Framework Code First with TPT Inheritance and Composite Keys

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related