EF Core return specific columns from child tables

EF return null for some but EF Core return 0

ZZZ_tmp

Return parents with null children using C# EF Core .Include

ZZZ_tmp

In EF Core how to select specific column and also save

ZZZ_tmp

EF Core - Can I make Entity Framework map only to only specific columns in the database?

ZZZ_tmp

Select only specific columns from included table in Entity Framework Core

ZZZ_tmp

EF core Database specific columns to nested object

ZZZ_tmp

Select specific table columns to list async using EF Core

ZZZ_tmp

Prevent EF Core From Updating A Column In A Specific Instance

ZZZ_tmp

Map column to child object in EF Core 3

ZZZ_tmp

Entity Framework Core Parent Child items in the same model, children node returns null

The second option is the proper one, however I have a suspicion that you are not eagerly gathering the kids while loading. Do this:...var one = context.Set<TestModel>().Include(x => x.children).FirstOrDefault(); ...Utilizing slow loading is an additional option. Check out more at ...https://docs.microsoft.com/en-us/ef/core/querying/related-data....