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

Junior .NET Developer
Source: Publishers Clearing House
Details: Windows Forms, WCF, ASP.NET, MVC. Publishers Clearing House (PCH), headquartered in Port Washington, NY (soon to be Jericho, NY!)....  More
14 days ago

Port Washington, NY 11050 12-April-2017

Senior .Net Developer
Source: Indeed
Details: Excellent server side development in ASP.NET, MVC, ADO.NET, LINQ, Web API, Windows Service and. We are looking for a strong, well rounded, self-motivated web...  More
4 days ago

Kingwood, TX 22-April-2017

Software Engineer C#/ASP.NET MVC/JavaScript
Source: Cormant, Inc.
Details: You will be working on full stack development including Marionette client, and a C# MVC architecture with NHibernate/RDBMS as the back-end....  More
5 days ago

San Luis Obispo, CA 21-April-2017

.NET Software Engineer
Source: CCC Information Services Inc.
Details: Sr. .NET Developer Cerritos, CA CCC Information Services, Inc. CCC provides the technology, data and insight needed to help our customers make informed,  More
5 days ago

Cerritos, CA 21-April-2017

Junior .Net Developer
Source: MassMutual Financial Group
Details: Experience working with WPF, CSS, Classic ASP, Infragistics controls, and SharePoint a plus, but not required. Junior .Net Developer....  More
20 days ago

Charlotte, NC 06-April-2017

Senior .Net Developer (Full-Stack)
Source: Indeed
Details: 4+ years of C# .NET and ASP.NET MVC development. Design, develop, and deliver web application components for a distributed system....  More
8 days ago

Austin, TX 18-April-2017

.Net Develoer
Source: conrep
Details: Experience with ASP.NET MVC and Bootstrap. The candidate also will work on the new custom modules/web sites developed in ASP.NET MVC C# platform....  More
12 days ago

Harrisburg, PA 17112 13-April-2017

Senior.Net Web Developer
Source: Indeed
Details: MVC. Our client – an established yet growing eCommerce firm seeks an accomplished .Net developer to fill a key role in the development of public-facing web...  More
6 days ago

Springfield, PA 19-April-2017

Senior .NET Developer
Source: Indeed
Details: *U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.* *Job Description: Senior .NET  More
14 days ago

Bloomfield, MI 12-April-2017

Junior to Mid-level .Net Developer
Source: Indeed
Details: Experience with the MVC pattern for web development. US Citizens or Greencard that do not require a Visa Sponsorhip for Full-Time Employment*....  More
7 days ago

Englewood, CO 18-April-2017

Junior .NET Developer
Source: NIC
Details: MVC. In-depth experience with C#, ASP.NET and MVC. Junior .Net Developer Position....  More
30+ days ago

Baton Rouge, LA 23-March-2017

.NET Software Engineer (Front End or Back End)
Source: Indeed
Details: Full stack Engineers will also get to work on our Front End within a ASP.NET MVC + JavaScript environment....  More
9 hours ago

San Diego, CA 92122 26-April-2017

Junior .NET Web Developer
Source: Indeed
Details: 1+ years experience ASP.NET MVC. The Award Zone provides tools for organizations to provide highly-effective motivational programs, such as employee reward and...  More
14 days ago

Atlanta North, GA 11-April-2017

Senior Software Developer .NET ASP.NET MVC
Source: Indeed
Details: Build new applications with .Net (C#) & ASP.NET MVC – heavy focus on client web portal. Reporting to the Vice President, Technology, the Senior Software...  More
25 days ago

New York, NY 10006 31-March-2017

Sr. C#/ASP.NET Developer
Source: Logic20/20
Details: *Strong C#, .NET framework (ASP.NET MVC, Entity Framework), jQuery, HTML 5 development Qualifications. Logic20/20 is a Seattle based Management & Technology...  More
8 days ago

Seattle, WA 98115 18-April-2017

Software Developer
Source: Indeed
Details: Experienced in ASP.NET MVC 5, CSS3, HTML5, JavaScript, JQuery, Knockout.js and AngularJs. This would be a managed service position:....  More
9 days ago

Seattle, WA 16-April-2017

.NET Software Engineer
Source: Shipbob
Details: We have opportunities to solve our clients needs with a wide variety of frameworks and platforms such as ASP.NET MVC, Azure SQL Server, Angular and many more....  More
20 days ago

Chicago, IL 06-April-2017

Software Development Engineer (.NET)
Source: Indeed
Details: Talentry is looking for a solid .net developer (c#, WCF, MVC, angular) with good communication skills who likes the idea of working in an environment that...  More
22 days ago

Irvine, CA 03-April-2017

Full stack .Net Mobile Application Developer
Source: Posh Technologies
Details: Visual Studio 2013+, C#, ASP.NET MVC 5 and Web API 2. 5+ years of working experience with C#, ASP.Net MVC, SQL Server, JavaScript....  More
5 days ago

Redmond, WA 21-April-2017

Software Engineer, Jr.
Source: Indeed
Details: HTML, HTML5, MVC, JavaScript, CSS, XML, SQL Server 2008/2014, Restful web services, AJAX, Testing Automation and OOD....  More
26 days ago

Phoenix, AZ 30-March-2017

Sitecore Developer
Source: Ursus Incorporated
Details: Solid experience with C#, ASP.NET, MVC, JavaScript, HTML5, CSS3, Razor. About the Role:....  More
19 hours ago

Sacramento, CA 95834 25-April-2017

Senior C#/.NET Full Stack Developer
Source: Graphic Products
Details: 3+ years demonstrated experience in ASP.NET MVC 4/5+. We are looking for a Senior Full Stack Developer responsible for the ongoing development and advancement...  More
30+ days ago

Beaverton, OR 97008 09-March-2017

Junior .NET Developer (no 3rd party candidates)
Source: Indeed
Details: Candidate must be clearable for a federal government public trust clearance; no third party candidates. *Responsible for developing and supporting .NET/C#  More
30+ days ago

Herndon, VA 16-March-2017

Front End Developer
Source: Indeed
Details: Microsoft ASP.NET MVC experience. Design, develop, and deliver front end web application components for a distributed system....  More
4 days ago

Annapolis, MD 21401 21-April-2017

.NET/C# Software Integration Engineer
Source: BlueVolt
Details: Solid programming experience with C#, WCF, Restful services using WEB API, and ASP.NET MVC. BlueVolt is growing....  More
29 days ago

Portland, OR 27-March-2017
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInDigg thisPin on Pinterest