Entity Framework 6 Eager Loading

By | December 30, 2016
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInDigg thisPin on Pinterest

In this Entity Framework Tutorial, we are going to understand about an important concept related to Object Relational Mapping that is “Eager Loading” with the help of a practical example. We already have discussed eager loading at high level, and another related concept “Lazy Loading” that is opposite to Eager Loading while discussing Entity Framework Interview Questions along with more Entity Framework concepts. To see a practical example for Lazy Loading in Entity Framework, follow here.

Eager loading is the process by which a query loads related entities along with it as part of the query. It is achieved by the using the “Include” method. For example, when querying orders, eager-load their product details also in a single query.

More Practical Entity Framework Tutorial

In order to practically grasp Entity Framework, we highly recommend to go through these real time implementations:


We have created 3 entities, Category, Products and Orders. In below diagram, entities with their relationships look as:Entity Framework Tutorial Eager Loading

The class of Products will look as:

The class of order entity will look as:

Following code does the eager loading in case of products and orders:

Resultant screen will be:EF Tutorial Eager Loading

In order to create an order, we can do as:

  • Learn ASP NET MVC 5 step by step [Maruti Makwana, Corporate Trainer] 28 Lectures, 2.5 Hours Video, Intermediate Level
    Very easy to learn video series on Asp.Net MVC 5 Specially for those who are familiar with Asp.Net Web forms.
  • AngularJS for ASP.NET MVC Developers [Brett Romero] 10 Lectures, 1 hour video, Intermediate Level
    The Fastest Way For .NET Developers To Add AngularJS To Their Resume
  • ASP.NET with Entity Framework from Scratch [Manzoor Ahmad, MCPD | MCT] 77 Lectures, 10 hour video, All Level
    Latest approach of web application development
  • Comprehensive ASP.NET MVC [3D BUZZ] 34 lectures, 14 Hours Video, All Levels
    From zero knowledge of ASP.NET to deploying a complete project to production.
The screen will look as:New Product EF Tutorial

This screen will place an order of products. As we have added foreign key constraint in orders with products. So with eager loading we can load the related product details while loading orders.

EF Eager Loading Example

After reading this Entity Framework Tutorial, it will be easy to implement eager loading in our application. Follow here to understand that correctly choosing between eager-loading and lazy-loading in practical scenarios.

You are working with WebDevTutorial and building an ADO.NET Entity Framework application for a client. You need to validate the conceptual schema definition language (CSDL), store schema definition language (SSDL), and mapping specification language (MSL) files. Which Entity Data Model tool can you use? (Each correct answer presents a complete solution. Choose all that apply.)

  • A. EDM Generator (EdmGen.exe)
  • B. ADO.NET Entity Data Model Designer
  • C. Update Model Wizard
  • D. Entity Data Model Wizard
  • E. All of Above
  • F. None of Above

For a complete online test and Practice Exams on Web Technologies, Click Here.

 Correct Answer: B, D

Top Technical Interview Questions and Answers Series:

ASP.NET MVC Jobs [Updated Daily]

Top ASP.NET MVC Jobs

Software Engineer I
Source: Vertafore
Details: Have developed either single page web applications leveraging modern frameworks (Angular, React) or more traditional multipage websites leveraging ASP.NET MVC...  More
27 days ago

Bothell, WA 98012 21-September-2017

Junior/Mid Level Software Developer
Source: Indeed
Details: ASP.NET MVC (C#). Software developers are the engine behind the design, development, installation, testing and maintenance of software systems....  More
13 hours ago

Kennesaw, GA 17-October-2017

Software Developer
Source: Mosaic Personnel
Details: Strong background in PHP, ASP.Net Web forms, ASP.NET MVC, C#. Why You'll Love This Software Developer Opportunity....  More
1 day ago

Oklahoma City, OK 17-October-2017

Applications Software Engineer - Web Developer Sr
Source: Indeed
Details: 5+ years' programming experience in C#, .NET framework, VB, MVC, EF and WCF. Experience with Web Development ASP.NET, ASP.NET, MVC, HTML5, CSS, JavaScript, AJAX...  More
15 hours ago

Anaheim, CA 17-October-2017

Software Developer
Source: Indeed
Details: Create ASP.NET MVC controllers to access databases. Knowledge of ASP.NET MVC is preferred but not required. Our development environment runs on the Microsoft...  More
4 days ago

Orlando, FL 13-October-2017

Software Developer
Source: SDHR Consulting
Details: .NET Stack experience (C#, ASP.NET MVC, MS SQL Server). Do you have a passion for writing code?...  More
5 days ago

San Diego, CA 13-October-2017

Software Developer / Software Engineer
Source: Natoli Engineering
Details: ASP.net MVC preferred. Software Developer / Software Engineer....  More
6 days ago

Saint Charles, MO 63304 11-October-2017

Software Developer
Source: Evergreen Enterprises
Details: ASP.Net, MVC development skills using MS Visual Studio; About Evergreen Enterprises....  More
6 days ago

Richmond, VA 23225 11-October-2017

Software Developer
Source: Reynolds and Reynolds
Details: Knowledge of .NET framework including C#, ASP.NET, MVC, JavaScript, JQuery, HTML, CSS, web services, XML and SQL....  More
9 days ago

Draper, UT 09-October-2017

Software Developer
Source: Indeed
Details: Knowledge in Visual Studio 2005-2013 and .NET Framework 2.0 - 4.5.1, ASP.NET MVC 5.0, VB 6.0/.NET, C, C++, C#, Java, Tomcat, Transact-SQL, HTML, XML, JavaScript...  More
12 days ago

San Juan, PR 05-October-2017

Software Developer - Medical Billing
Source: SyMed Corporation
Details: Experience with ASP.NET MVC 5, LINQ, Entity Framework 6. Located in the beautiful Napa Valley, SyMed Corporation is a comprehensive medical billing and...  More
13 days ago

Napa, CA 94558 05-October-2017

Software Application Developer
Source: Indeed
Details: Successful candidates will likely have at least 5 years of experience in a professional capacity and a Bachelor’s degree in Computer Science, Information...  More
13 days ago

Los Angeles, CA 04-October-2017

Sr Software Developer
Source: Indeed
Details: C#, ASP.NET MVC. System redesign includes Car Buying, Retail and Scrap operations (using Mobile, MVC Web, WPF, Xamerin tablet interfaces)....  More
13 days ago

Atlanta, GA 30360 04-October-2017

Software Developer - Mid Level
Source: MartinFederal Consulting
Details: ASP.NET MVC and Web Forms. MartinFederal is seeking a self-motivated candidate for our Mid-Level Software Developer position in support of our DoD customer at...  More
16 days ago

Fort Meade, MD 20755 01-October-2017

Software Developer
Source: Gagemaker LP
Details: Intermediate to advanced skills in ASP.NET MVC , ASP.NET Web API. Software Developer Position Summary:....  More
19 days ago

San Antonio, TX 78216 28-September-2017

Software Developer ; Front-end
Source: Indeed
Details: If you are passionate about technology and enjoy creating simple solutions to complex requirements -- come join us! We are looking for topnotch developers...  More
20 days ago

San Diego, CA 27-September-2017

Software Developer 3
Source: Almac Group, Inc
Details: Minimum 2 years of experience developing applications utilizing ASP.net MVC and C#. 3 or more years of C# and ASP.net MVC experience working in a regulated...  More
27 days ago

Durham, NC 27704 20-September-2017

Software Developer
Source: Indeed
Details: Expertise should include HTML5, AngularJS, JavaScript, ASP.NET MVC and CSS. A solid understanding of working with MVC JavaScript frameworks such as Angular....  More
28 days ago

Carlsbad, CA 20-September-2017

Software Developer
Source: Indeed
Details: ASP.NET MVC, Web API. NET Framework 4.0 and above. Software Developer (.NET)*....  More
28 days ago

San Diego, CA 19-September-2017

Software Developer
Source: Indeed
Details: Experience with ASP.NET MVC and Web API. Client Resources Inc....  More
29 days ago

Lincoln, NE 18-September-2017

Software Developer
Source: Indeed
Details: 3+ years of experience with C# and ASP.NET MVC. The Software Developer will assist with new and ongoing software development as a member of an agile team...  More
22 days ago

Kennesaw, GA 25-September-2017

Software Developer 2
Source: Almac Group, Inc
Details: Minimum 1 year of experience developing applications utilizing ASP.net MVC and C#. Almac is an exceptional, award winning, drug development solutions provider...  More
29 days ago

Audubon, PA 19403 18-September-2017

Software Developer 2
Source: Almac Group, Inc
Details: Minimum 1 year of experience developing applications utilizing ASP.net MVC and C#. Almac is an exceptional, award winning, drug development solutions provider...  More
30+ days ago

Lansdale, PA 19446 14-September-2017

Software Engineer/Developer
Source: ITR (Information Technology Resources)
Details: Candidates demonstrating applied experience with ASP.NET MVC, Java, and Linux will be given extra consideration....  More
30+ days ago

Oak Ridge, TN 07-September-2017

Software Engineer/Developer
Source: ITR (Information Technology Resources)
Details: The qualified candidate will be responsible for development and coding Web and desktop applications in the .NET Framework, SQL Server, and ASP.NET MVC....  More
30+ days ago

Knoxville, TN 04-September-2017
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInDigg thisPin on Pinterest