/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 vote188 views1 answer
C# create console for winform
C#
1 vote190 views2 answers
C# delay
C#
7 votes176 views2 answers
Insert variables into a string C#
C#
3 votes182 views1 answer
C# yes or no dialog
C#
0 vote182 views1 answer
StackTrace getframe last frame
C#
0 vote198 views1 answer
C# linq mselect
C#
2 votes196 views1 answer
C# convert dictionary to anonymous object
C#
2 votes175 views2 answers
C# dictionary values to list
C#
1 vote269 views1 answer
Get appdata file path c#
C#
-1 vote180 views1 answer
How to make a .exe file in c# visual studio
C#