/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

2 votes124 views1 answer
Snx disconnect linux
C#
0 vote122 views1 answer
How to add to a list only items that are not already in the list c#
C#
24 votes112 views1 answer
Csharp datetime string format
C#
0 vote122 views1 answer
C# select keyword lambda
C#
0 vote121 views1 answer
Discord bot c# reply to command in dms
C#
0 vote118 views2 answers
C# api get value from header
C#
0 vote114 views1 answer
C# mock ref parameter
C#
0 vote121 views1 answer
Unity game object remove parent
C#
2 votes150 views2 answers
Unity get all components in gameobject
C#Unity
0 vote125 views2 answers
RadioButton IsChecked mapped to ENum xmal
C#