Home > DeveloperSection > Interviews > What is Lazy, Eager, and Explicit Loading of Related Data in Entity Frameworks

Posted on    February-26-2016 11:46 PM

 1 Answer(s)
  456  View(s)
Rate this:

Anupam Mishra

Total Post:23

Posted on    February-27-2016 12:46 AM

There are several ways that the Entity Framework can load related data into the navigation properties of an entity:

Lazy loading. When the entity is first read, related data isn't retrieved. However, the first time you attempt to access a navigation property, the data required for that navigation property is automatically retrieved. This results in multiple queries sent to the database — one for the entity itself and one each time that related data for the entity must be retrieved.

Eager loading. When the entity is read, related data is retrieved along with it. This typically results in a single join query that retrieves all of the data that's needed. You specify eager loading by using the Include method.

Explicit loading. This is similar to lazy loading, except that you explicitly retrieve the related data in code; it doesn't happen automatically when you access a navigation property. You load related data manually by getting the object state manager entry for an entity and calling the Collection.Load method for collections or the Reference.Load method for properties that hold a single entity. 

Don't want to miss updates? Please click the below button!

Follow MindStick