loading a full hierarchy from a self referencing table with EntityFramework.Core

by

In fact loading the whole hierarchy is quite easy thanks to the so called EF (Core) relationship fixup.

Let say we have the following model:

public class Hierarchy
{
    public int Id { get; set; }
    public string Name { get; set; }
    public Hierarchy Parent { get; set; }
    public ICollection<Hierarchy> Children { get; set; }
}

Then the following code

var hierarchy = db.Hierarchy.Include(e => e.Children).ToList();

will load the whole hierarchy with correctly populated Parent and Children properties.

The problem described in the referenced posts arise when you need to load just part of the hierarchy, which is hard due to the lack of CTE like support in LINQ.

More Related Contents:

  1. Dynamically access table in EF Core 2.0
  2. Can’t use Count() in C#
  3. Dynamically change connection string in Asp.Net Core
  4. How to mock an async repository with Entity Framework Core
  5. .Net Core 3.0 possible object cycle was detected which is not supported
  6. .NET Core 2.1 Identity get all users with their associated roles
  7. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  8. How to instantiate a DbContext in EF Core
  9. Command dotnet ef not found
  10. Unable to create migrations after upgrading to ASP.NET Core 2.0
  11. Dynamically changing schema in Entity Framework Core
  12. How to unapply a migration in ASP.NET Core with EF Core
  13. EF CORE 2.1 HasConversion on all properties of type datetime
  14. Is there an Entity Framework 7 Database-First POCO Generator?
  15. How to make EF-Core use a Guid instead of String for its ID/Primary key
  16. The LINQ expression could not be translated and will be evaluated locally
  17. In-memory database doesn’t save data
  18. Configuring Dbcontext as Transient
  19. EF Core queries all columns in SQL when mapping to object in Select
  20. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  21. Add migration with different assembly
  22. ASP – Core Migrate EF Core SQL DB on Startup
  23. Entity Framework core – Contains is case sensitive or case insensitive?
  24. Entity Framework Core: `SqlNullValueException: Data is Null.` How to troubleshoot?
  25. How to load navigation properties on an IdentityUser with UserManager
  26. How to get user information in DbContext using Net Core
  27. How should I manage DbContext Lifetime in MVC Core?
  28. Implementing recursive property loading in EF Core
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists

Leave a Comment