Eager loading in ASP.NET MVC 3 (Entity Framework)

Question

I have a simple data structure

Employee
Employee has List
Education has University, Department
Department and University has Name as string (I mean Dept. and Univ. are also entity)

My question is, how can I eagerly load specific Employee's education list and each education's university and department information in Entity Framework.

In ASP.NET MVC tutorials there is a query like:

var viewModel = new InstructorIndexData();
viewModel.Instructors = db.Instructors
    .Include(i => i.OfficeAssignment)
    .Include(i => i.Courses.Select(c => c.Department))
    .OrderBy(i => i.LastName);

But my include takes only string parameter (with using System.Linq)

How can I solve this problem?

Thank you...

Raphaël Althaus · Accepted Answer · 2012-03-06 10:24:29Z

4

Is't not in System.Linq, but in System.Data.Entity (so using System.Data.Entity) and exists in EF 4.1, but I must admit I don't know in which version it appeared.

answered Mar 6, 2012 at 10:24

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

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

1 Comment

Turkdogan Tasdelen Over a year ago

Thank you! I updated to Entity Framework 4.3. using.System.Data.Entity worked for me.

Henk Holterman · Accepted Answer · 2012-03-06 10:10:22Z

2

That snippet is for a new version of EF I thin. What 4.x version are you using?

You should be able to use the name(s) of the Navigation properties:

viewModel.Instructors = db.Instructors
    .Include("OfficeAssignment")
    .Include("Courses.Department")   // not so sure about this one
    .OrderBy(i => i.LastName);

answered Mar 6, 2012 at 10:10

Henk Holterman

276k33 gold badges353 silver badges540 bronze badges

Collectives™ on Stack Overflow

Eager loading in ASP.NET MVC 3 (Entity Framework)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related