/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

0 vote312 views1 answer
Create a list of 3 Orders c#
C#
0 vote313 views1 answer
Verifyusertokenasync password reset token
C#
1 vote297 views1 answer
C# unity get lines
C#
0 vote292 views1 answer
Creating a streamwiter file C#
C#
1 vote319 views1 answer
C# add int var
C#
1 vote295 views1 answer
Set textbox colour to transparent c#
C#
0 vote325 views1 answer
How to do division with button C#
C#
0 vote333 views1 answer
Unity agent look at
C#Unity
2 votes332 views3 answers
C# while true loop
C#
2 votes289 views2 answers
Rotation unity script 2d
C#