Get all children of same object by Entity Framework-CodePudding

I need your help. I have next simple class:

public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int ParentId { get; set; }
    public IEnumerable<Person> People { get; set; }
}

I need to get class by ID and all children of the class that have ParentId same with ID of first class (and children of children)? I need to use LINQ filtration. Thanks for help!

CodePudding user response：

Okay, there are two solutions that I could find. The first is using the recursive method on the server-side. But in this variant, you need each time request database for each level of hierarchy. The best solution is using Recursion in SQL. You need to do only one request to the database. I attach the link. https://medium.com/swlh/recursion-in-sql-explained-graphically-679f6a0f143b