Entity Framework Core - Knowledge Base (KB)

LINQ query to get recursive category structure and products of each category

How can I re-write my query to include all the products of each category in a recursive product category tree? This query gets the categories and their children, so I'm just missing the products:...var categories = _context.ProductCategories ...

How can I load all child records recursively?

I have this Project class:...public class Project { public int Id { get; set; } public int? ParentId { get; set; } public List<Project> ChildProjects { get; set; } // more properties } ...This is my attempt to load all descendants of any g...