/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

5 votes129 views2 answers
C# mark as deprecated
C#
1 vote175 views1 answer
Unity script detect if in prefab edition mode
C#Unity
0 vote124 views1 answer
Moq Unittest with ILogger
C#
0 vote121 views1 answer
CS0176
C#
1 vote181 views1 answer
C# check if string is path or file
C#
0 vote120 views1 answer
Async where linq
C#
1 vote130 views1 answer
Animations for pause menu
C#
1 vote121 views1 answer
Unity put children in list
C#Unity
0 vote159 views1 answer
Find qual values in a dictionary c#
C#
0 vote122 views1 answer
Unity how to find the largest value out of 2 numbers
C#