Map category parent id self referencing table structure to EF Core entity
EF (and LINQ in general) has issues loading tree like data due to lack of recursive expression/CTE support. But in case you want to load the whole tree (as opposed to filtered tree branch), there is a simple Include based solution. All you need is a single Include and then the EF navigation property fixup … Read more