Disable lazy loading by default in Entity Framework 4

by

The following answer refers to Database-First or Model-First workflow (the only two workflows that were available with Entity Framework (version <= 4.0) when the question was asked). If you are using Code-First workflow (which is available since EF version >= 4.1) proceed to ssmith’s answer to this question for a correct solution.

The edmx file has in the <ConceptualModel> and <EntityContainer> definition an attribute for lazy loading where you can set lazy loading generally to false:

<EntityContainer Name="MyEntitiesContext" annotation:LazyLoadingEnabled="false">

This creates the following setting in the ObjectContext constructor:

public MyEntitiesContext() : base("name=MyEntitiesContext", "MyEntitiesContext")
{
    this.ContextOptions.LazyLoadingEnabled = false;
    OnContextCreated();
}

My example is not meant that way that the generated ObjectContext (or DbContext in newer EF versions) should be edited manually (which would be overwritten with every model update from the database, as ctorx pointed out) but that the EntityContainer element in the edmx:ConceptualModels section of the EDMX file should be edited by adding the annotation:LazyLoadingEnabled="false" attribute – either manually in an XML editor or on the properties page of the designer surface where this option is available as well, Right-Click EDMX then Properties.

enter image description here

This modification of the EDMX file will automatically generate the context class with the disabled lazy loading option in the constructor like shown above. The EDMX file modification itself does not get overwritten when the model is updated from the database.

More Related Contents:

  1. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  2. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  3. How to include a child object’s child object in Entity Framework 5
  4. Entity Framework 4 / POCO – Where to start? [closed]
  5. Entity Framework Code First Lazy Loading
  6. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  7. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  8. Unique keys in Entity Framework 4
  9. Entity Framework 4 selective lazy loading properties
  10. Upgrade EF 4 EDMX to EF 6
  11. Querying objects after AddObject before SaveChanges?
  12. EF Migrations: Rollback last applied migration?
  13. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  14. Using Entity Framework with an SQL Compact Private Installation
  15. Map two different entities to the same table?
  16. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  17. What would cause the Entity Framework to save an unloaded (but lazy loadable) reference over existing data?
  18. AutomaticMigrationsEnabled false or true?
  19. Compose queries across Entity Data Models
  20. Changing Inherited Types in Entity Framework
  21. Why does the entity framework need an ICollection for lazy loading?
  22. Reset Entity-Framework Migrations
  23. Entity Framework Join 3 Tables
  24. Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93
  25. Entity Framework/Linq EXpression converting from string to int
  26. “like” queries in Entity Framework
  27. Entity Framework Include() is not working
  28. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  29. MetadataException when using Entity Framework Entity Connection [duplicate]
  30. How to Refresh DbContext

Leave a Comment