How to get hierarchy(children or parent's), using LINQ to EF Core

Question

I have a data structure, such as next
class Entity
{
int Id,
int EntityParentId,
string Name
}
And I would like to get all children or parents, could you help me how can I do it with C# LINQ

Answer 1

If you mean child as a navigation property of a model than try the following extension method.

public static class DbContexts  
{  
  
	public static void GetNavigationDetails(this DbContext context)  
	{  
		var modelData = context.Model.GetEntityTypes()  
			.Select(entityType => new  
			{  
				entityType.ClrType.Name,  
				NavigationProperties = entityType.GetNavigations().Select(x => x.PropertyInfo)  
			}).ToList();  
  
		foreach (var item in modelData)  
		{  
			Console.WriteLine($"Model name: {item.Name}");  
			foreach (var info in item.NavigationProperties)  
			{  
				Console.WriteLine($"\t{info.Name}");  
			}  
		}  
	}  
}  

Usage

using CustomerContext context = new();  
context.GetNavigationDetails();