Entity Framework table per type - select from only the base type columns

Viewed 1369

We are using EF 4.3 Code first and have an object model like so:

class Content {  }

class Product:Content { }

class News:Content { }

These are mapped as Table per Type.

There are scenarios where I just want to load only the columns belonging to the base table, like say a list of all the content titles. But a query like

from c in Content
where c.IsDeleted == false
select c

results in some really nasty SQL with joins to the other two tables. Is there any way to force EF to just do a select from the base table only without joins to the other tables?

1 Answers
Related