Lazy Loading not working in EntityFramework Core

Question

Below are two classes that control database tables using Code First Entity Framework (DbContext).

public class Employee
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    public string EmployeeName { get; set; }

    public int DepartmentId { get; set; }

    public Department Department { get; set; }

}

--

public class Department
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    public string DepartmentName { get; set; }
}

If I retrieve the employees with the line below the navigation property for Department is null:

        var employees = _context.Employees.ToList();

However, if I first populate a separate variable with Departments, like this ...

        var departments = _context.Departments.ToList();

        var employees = _context.Employees.ToList();

... Each employee in the employees list contains the Department object.

My question: What is best practice to populate the navigation property? I had imagined that Entity Framework would have done this by default and that the ToList() method would handle the lazy loading.

If by notification property you mean navigation property, search for EF lazy loading, eager loading and explicit loading to learn which one is appropriate for you (there is no "best"). — Ivan Stoev
– Ivan Stoev, Commented Apr 2, 2017 at 18:49
Yes, I was referring to navigation property. I'll correct the question. As for lazy/eager loading: Shouldn't the ToList() method load the data? — Sparked
– Sparked, Commented Apr 2, 2017 at 18:51
It loads only that data, e.g. Employees, but not related data like Employee.Department. See msdn.microsoft.com/en-us/library/jj574232(v=vs.113).aspx — Ivan Stoev
– Ivan Stoev, Commented Apr 2, 2017 at 18:57
Thank you. That's clear and solved my problem, I had looked for the Include() method but was missing using Microsoft.EntityFrameworkCore; — Sparked
– Sparked, Commented Apr 2, 2017 at 19:12

Tseng · Accepted Answer · 2017-04-02 20:38:55Z

3

Reading the docs/roadmap you'd have realized that lazy loading is not yet supported in EF Core 1.0/1.1.

Currently only .Include or eager loading is supported, both well documented in the documentation.

You must not assume that all features from EF 6 are available in EF Core. EF Core is a complete rewrite and do not include many of the features of EF6. If you need any of that stuff, you should keep using EF6 instead.

EF Core is good enough for most simple/basic ORM stuff, but even Microsoft recommends to use EF6 for production where you depend on these features.

answered Apr 2, 2017 at 20:38

Tseng

64.5k18 gold badges200 silver badges215 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

George Wurthmann · Accepted Answer · 2019-03-17 01:05:38Z

2

I solved my problem in EF Core 2.1 using UseLazyLoadingProxies:

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder
        .UseLazyLoadingProxies();

You now need to manually specify that you want it enabled.

answered Mar 17, 2019 at 1:05

George Wurthmann

4892 gold badges10 silver badges22 bronze badges

1 Comment

Rob Koch Over a year ago

To be able to get that included, it's a separate Nuget package you'll have to pull down: Microsoft.EntityFrameworkCore.Proxies

Collectives™ on Stack Overflow

Lazy Loading not working in EntityFramework Core

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related