Loading in Entity Framework

Loading Related Entities
Entity Framework supports three ways to load related data - eager loading, lazy loading and explicit loading. The techniques shown in this topic apply equally to models created with Code First and the EF Designer.

Eagerly Loading
Eager loading is the process whereby a query for one type of entity also loads related entities as part of the query. Eager loading is achieved by use of the Include method. For example, the queries below will load blogs and all the posts related to each blog.

using (var context = new BloggingContext())

{

    // Load all blogs and related posts

    var blogs1 = context.Blogs

                .Include(b => b.Posts)

                .ToList();

    // Load one blogs and its related posts

    var blog1 = context.Blogs

                .Where(b => b.Name == "ADO.NET Blog")

                .Include(b => b.Posts)

                .FirstOrDefault();

    // Load all blogs and related posts 

    // using a string to specify the relationship

    var blogs2 = context.Blogs

                .Include("Posts").ToList();

         // Load one blog and its related posts 

        // using a string to specify the relationship

        var blog2 = context.Blogs

            .Where(b => b.Name == "ADO.NET Blog")

            .Include("Posts")

            .FirstOrDefault();

          // Load all blogs, all related posts, and all related comments

          var blogs1 = context.Blogs

            .Include(b => b.Posts.Select(p => p.Comments))

            .ToList();

}

Lazy Loading

Lazy loading means delaying the loading of related data until you specifically request it. lazy loading feature of entity framework to load the related data in scalar and navigation properties only when you use it but not at first shot. lazy loading is opposite of Eager loading.

Explicitly loading

for more info Visit : Click Here