EF Where clause in an Include

Question

from this example that I stole from the net:

Company company = context.Companies
                     .Include("Employee.Employee_Car")
                     .Include("Employee.Employee_Country")
                     .FirstOrDefault(c => c.Id == companyID);

if I want a where clause in the include of Employee_Car for example, how do I do that? Say I just want it to retrieve blue cars.

Thanks

score 4 · Accepted Answer · edited May 23 '17 at 12:04

Short answer is you can't do it just through using the include. You will need to do a bit of joining. So taking this tip post and the SO answer you could do something like along these lines. (Note not exactly your return type but the closest)

var companyBlueCars = from company in context.Companies
                      where company.Id == companyID 
                      select new 
                      {
                          company,
                          blueCars = from employee in company.Employees
                                     where employee.Employee_Car.Colour == "blue"
                                     select employee.Employee_Car
                      };

(I did make a couple guesses about the data structure but the idea is there.)

That's cool, I borrowed the example from another question here because it probably makes more sense than my financial modelling one :) Thanks for the help :) — Ian, Aug 24 '12 at 09:41

score 1 · Answer 2 · answered Aug 23 '12 at 20:48

1

You will not do that because include doesn't support filtering or sorting. You must execute two separate queries to load companies and cars with their filters.

answered Aug 23 '12 at 20:48

Ladislav Mrnka

360,892
59
660
670

EF Where clause in an Include

2 Answers2