Entity Framework Core - Knowledge Base (KB)

EF Core nested Linq select results in N + 1 SQL queries

I have a data model where a 'Top' object has between 0 and N 'Sub' objects. In SQL this is achieved with a foreign key ...dbo.Sub.TopId.......var query = context.Top //.Include(t => t.Sub) Doesn't seem to do anything .Select(t => new { pro...