Accepted answer

I was trying in EF 4.0 either we have write DB extentions for the same.

Option is provided in EF 4.1



You can look at the Expression the compiler generates using IQueryable:

IQueryable<Employee> query = 
  from ee in entities.Employee ...

var expression = query.Expression;

Look at expression in a debugger to see what you need to generate - LINQPad is good for this.

You might want to simplify your query a bit first:

IQueryable<Employee> query = 
  from ee in entities.Employee.Include("EmpEduInfo")                           
  where"t") &&
    ee.EmpEduInfo.Any(x =>"t"))                             
  select ee;

Related Articles