KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
IQueryable<Employee> emps = CreateObjectSet<Employee>() .Include(u => u.Departments) .AsQueryable(); IQueryable<Products> prods = CreateObjectSet<Products>().AsQueryable(); CreateObjectSet is ObjectContext's CreateObjectSetMethod return (from emp in emps join prod in prods on emp.ProductID equals prod.ProductID where emp.EmployeeID == 10 select employee).ToList(); The problem is from the first line, i use the include statement and include departments with the employees the return values does not have departments with as they are never included. Kindly suggest something. This is just a demo query, actual query is far complex, so please don't suggest that i should not go with the join statement, but simple include and where clause, that does not serve me ni my scenario. Thanks
Tags (comma-separated)
Save Edits
Cancel