WHAT IS LAZY, EAGER, AND EXPLICIT LOADING OF RELATED DATA IN ENTITY FRAMEWORKS

Anupam Mishra

Total Post:23

Points:115
Posted by  Anupam Mishra
 492  View(s)
Ratings:
Rate this:
  1. Anupam Mishra

    Post:23

    Points:115
    What is Lazy, Eager, and Explicit Loading of Related Data in Entity Frameworks


    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. 

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!