Deriving 2 times on Entity Framework

Question

Hello everybody

Let's say we have tables named A, B, C . C derived from B and B derived from A. So if i want to get C table, OfType(C) will bring result as expected. But if i wrote OfType(B) result will include entries of table C.

How i could get result just for B ? Is there better solution of Entity Framework ?

Answer 1

There's probably a better/faster/sexier way to do this, but you could always do something with LINQ:

var results = yourCollectionOfBsAndCs.Where(o => !(o is C));

Answer 2

If we try to exclude inherited classes so we have to write all of them and we should to update our code if there will be another inherited classes in future. So instead of them this code will be better solution.

//collection include classes A and inherited classes from A.
collection.Where(o => o.GetType() == typeof(A));