/C#/Linq query to fetch parent child data from same table in c#

Linq query to fetch parent child data from same table in c#

var v = from p in db.tableName
        select new
        {
          ParentID = p.SerialNo,
          child = from c in db.tableName
                  where c.Parent == p.SerialNo select
                  new
                  {
                    ChildID = c.SerialNo,
                    ParentID = c.Parent
                  }
        };

Similar codes

3 votes103 views2 answers
If string contains number c#
C#
0 vote104 views1 answer
System.drawing.color to system.consolecolor
C#
0 vote98 views4 answers
Hovercraft Physics in Unity
C#
9 votes95 views2 answers
C# null conditional
C#
1 vote96 views1 answer
Access a local varible in a different function C#
C#
4 votes97 views1 answer
Asp.net data annotations email
C#
23 votes139 views2 answers
Waitforseconds unity
C#Unity
0 vote100 views3 answers
Published net core did not have wwwroot
C#
0 vote99 views1 answer
Freeze scene unity
C#
21 votes125 views2 answers
Press key run code unity c#
C#Unity