Entity Framework: How to disable lazy loading for specific query?

c# entity-framework lazy-loading
Marco Alves picture Marco Alves · Jun 3, 2014 · Viewed 78.9k times · Source

Is there any way to disable lazy loading for specific query on Entity Framework 6? I want to use it regularly, but sometimes I want to disable it. I'm using virtual properties to lazy load them.

Answer

Karthik Ganesan picture Karthik Ganesan · Jun 6, 2016

set the following code before the query you want to execute

context.Configuration.LazyLoadingEnabled = false;

Related questions

Entity Framework Code First Lazy Loading

I am having two object classes public class User { public Guid Id { get; set; } public string Name { get; set; } // Navigation public ICollection<Product> Products { get; set; } } public class Product { public Guid Id { get; set; } // Navigation public User User { …

Read More
Eager , Lazy and explicit loading in EF6

I have read this tutorial and this article but I don't understand exactly the use of each loading type. I Explain I have this POCO : public partial class dpc_gestion { public dpc_gestion() { this.ass_reunion_participant = new HashSet<…

Read More
Entity Framework Eager Load Not Returning Data, Lazy Load Does

I'm using code first EF5 and I have an object which has a collection defined as virtual (lazy loaded). This returns data when called. However I want it to be eager loaded. I've removed virtual from the property signature but …

Read More