EF Code First forced eager loading

Question

EF Code First forced eager loading

code-first ef-code-first entity-framework

Question

I'm using EF 5 with Code First. I have a class that I want to always eager load some properties. I removed the virtual keyword but it's not eager loading:

public class Person
{
   public ICollection<Email> Emails { get; set; } 
   public Profile Profile {get;set;}
}

So by turning off lazy loading, it won't auto eager load right? If so, how do I archive that without using Include()?

Thanks!

Calvin

View more on Stack Overflow

Paul · Accepted Answer · 8/22/2012 12:41:07 AM

No, turning off lazy loading by removing the virtual keyword will not automatically enable eager loading. You have to Include the related Entity or Collection like so:

var personWithProfile = ctx.People.Include(x => x.Profile).First();
var personWithProfileAndEmails = ctx.People.
                                           .Include(x => x.Profile)
                                           .Include(x => x.Emails)
                                           .First();

This is a great read from the ADO.NET team blog: http://blogs.msdn.com/b/adonet/archive/2011/01/31/using-dbcontext-in-ef-feature-ctp5-part-6-loading-related-entities.aspx

EF Code First forced eager loading

Question

Fastest Entity Framework Extensions

Accepted Answer

Performance

Expression Evaluator

Related