CODEWITHSUNDEEP
inheritanceentity-framework-4dbcontextdatabase-firsttable-per-hierarchy
ckonig
ckonig

Reputation: 1234

EF: select all entities of subclass (inheritance)

I am using the Database first approach and DbContext. I have several inheritance structures (TPH) in my data model. But DbContext only creates one DbSet for the base class, and none for the subclasses. How should I retrieve all Entities of a specified subclass?

I cannot write queries based on the mapping criteria, as i had to remove those fields from the data model.

Can I simply add a new DbSet to the Entities class (partial class) ?

Upvotes: 2

Views: 1579

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364319

You can add new properties returning DbSets of your derived types into context's partial class or you can simply use OfType<DerivedType>() operator when querying sets created by the code generator.

Upvotes: 7

Related Questions