Self Join EF Tables and Get Parent Child Relation

 using (var context = new YourDbContext())
        {
            // Query for top-level parents and their children
            var resources = context.Resources
                .Include(r => r.Children) // Eager load children
                .Where(r => r.ParentId == null)
                .ToList();

            foreach (var resource in resources)
            {
                Console.WriteLine($"Parent: {resource.Name}");
                foreach (var child in resource.Children)
                {
                    Console.WriteLine($"- Child: {child.Name}");
                }
            }
        }