Entity Framework Eager Load Not Returning Data, Lazy Load Does

by

This is a common confusion. The opposite of lazy loading is: no loading unless you explicitly do the loading yourself (e.g. by eager loading using Include).

So if you turn off lazy loading in any way — removing the virtual modifier is one of them — the behaviour does not turn into eager loading but no loading.

Think of it, suppose EF would eagerly load everything that is not marked for lazy loading. You run the risk of loading half the database by doing one simple query!

There is no way to make a navigation property eager loading by default (if you’d still want that after reading the above).

More Related Contents:

  1. Entity Framework Code First Lazy Loading
  2. How to declare one to one relationship using Entity Framework 4 Code First (POCO)
  3. Eager , Lazy and explicit loading in EF6
  4. Entity Framework: How to disable lazy loading for specific query?
  5. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  6. Entity Framework change connection at runtime
  7. Entity Framework Provider type could not be loaded?
  8. Entity Framework Refresh context? [closed]
  9. EntityType has no key defined error
  10. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  11. LEFT JOIN in LINQ to entities?
  12. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  13. Insert data using Entity Framework model
  14. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  15. How to compare only date components from DateTime in EF?
  16. Entity Framework 6 Code First Custom Functions
  17. Entity Framework Filter “Expression”
  18. How to get property change notifications with EF 4.x DbContext generator
  19. Order by dynamic parameter
  20. Problems using Entity Framework 6 and SQLite
  21. The remote server returned an unexpected response: (413) Request Entity Too Large.
  22. Self-referencing many-to-many recursive relationship code first Entity Framework
  23. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  24. Log Queries executed by Entity Framework DbContext
  25. Entity Framework Code First Date field creation
  26. Unable to find the requested .Net Framework Data Provider. It may not be installed
  27. Entity framework: StoreGeneratedPattern=”Computed” property
  28. The entity type ‘IdentityUserLogin’ requires a primary key to be defined [duplicate]
  29. Should Entity Framework Context be Put into Using Statement?
  30. How to use String property as primary key in Entity Framework

Leave a Comment