EF Core returns null relations until direct access

Question

I have some models like those below:

public class Mutant {     public long Id { get; set; }     ...      // Relations     public long OriginalCodeId { get; set; }     public virtual OriginalCode OriginalCode { get; set; }     public int DifficultyLevelId { get; set; }     public virtual DifficultyLevel DifficultyLevel { get; set; } } 

and

public class OriginalCode {     public long Id { get; set; }     ...      // Relations     public virtual List<Mutant> Mutants { get; set; }     public virtual List<OriginalCodeInputParameter> OriginalCodeInputParameters { get; set; } } 

and in the OnModelCreating of DBContext I made the relations like these:

        modelBuilder.Entity<Mutant>()             .HasOne(m => m.OriginalCode)             .WithMany(oc => oc.Mutants)             .HasForeignKey(m => m.OriginalCodeId)             .OnDelete(Microsoft.EntityFrameworkCore.Metadata.DeleteBehavior.Restrict);          modelBuilder.Entity<Mutant>()             .HasOne(m => m.DifficultyLevel)             .WithMany(dl => dl.Mutants)             .HasForeignKey(m => m.DifficultyLevelId)             .OnDelete(Microsoft.EntityFrameworkCore.Metadata.DeleteBehavior.Restrict); 

now when I request for Mutants, the OriginalCode is null:

but as soon as I request for OriginalCodes like below:

then the OriginalCode field of the mutants will be not null:

What is the reason and how could I fix it?

Answer 1

The reason is explained in the Loading Related Data section of the EF Core documentation.

The first behavior is because EF Core currently does not support lazy loading, so normally you'll get null for navigation properties until you specifically load them via eager or explicit loading. However, the Eager loading section contains the following:

Tip
Entity Framework Core will automatically fix-up navigation properties to any other entities that were previously loaded into the context instance. So even if you don't explicitly include the data for a navigation property, the property may still be populated if some or all of the related entities were previously loaded.

which explains why the navigation property is not null in the second case.

Now, I'm not sure which of the two behaviors do you want to fix, so will try to address both.

The first behavior can be "fixed" by using one of the currently available methods for loading related data, for instance eager loading:

var mutants = db.Mutants.Include(m => m.OriginalCode).ToList(); 

The second behavior is "by design" and cannot be controlled. If you want to avoid it, make sure to use fresh new DbContext instance just for executing a single query to retry the data needed.

Update: Starting with v2.1, EF Core supports Lazy Loading. However it's not enabled by default, so in order to utilize it one should mark all navigation properties virtual, install Microsoft.EntityFrameworkCore.Proxies and enable it via UseLazyLoadingProxies call, or utilize Lazy-loading without proxies - both explained with examples in the EF Core documentation.