How to do "nested" eager loading in Entity Framework?

Question

Scenario:

Employee:     EmployeeId   (PK)    DepartmentId_FK  (FK)   Name and other fields
Department:   DepartmentId (PK)    CompanyId_FK     (FK)   Name and other fields
Company:      CompanyId    (PK)                            Name and other fields

How can I build a linq query that can join the three tables and returns EmployeeName, DepartmentName and CompanyName?

the following syntax does not work because there is no Navigation Property names Company on Employee.cs.

var model = DataContext.Employee
                .Include("Employer")
                .Include("Company");

What is the correct way to do this?

possible duplicate of How to load nested Entity Framework objects efficiently — Codeman
– Codeman, Commented Jul 17, 2014 at 21:18

Jomit · Accepted Answer · 2012-11-30 18:59:05Z

3

Try this :

 var data = DataContext.Employees.Include("Department").Include("Department.Company");

But use this with caution as eager loading can hurt back if there is large amount of data.

answered Nov 30, 2012 at 18:59

Jomit

6164 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richard Deeming Over a year ago

You don't need the Include("Department"); that's implied by the Include("Department.Company"). See the remarks at: msdn.microsoft.com/en-us/library/bb738708.aspx

Collectives™ on Stack Overflow

How to do "nested" eager loading in Entity Framework?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related