Get data on the basis of conditions in entity framework 3.5 with include
- by Ashwani K
Hello All:
I am using entity framework 3.5 for my application.
I want load data based on some condition e.g.
var data = from e in context.Employee.Include("Employee.Projects") where e.IsActive select e;
Using this, I will get all the Employees which are active with their project details. But I want to load only those projects which are active. So, how to load only active projects using the query?
Thanks
Ashwani