/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 vote228 views1 answer
Exceldatareader example c#
C#
0 vote299 views1 answer
HttpClient .net Core add Certificate
C#
0 vote172 views1 answer
The process cannot access the file because it is being used by another process. press any key to continue...
C#
0 vote190 views1 answer
C# treeview keep selected node highlight
C#
1 vote157 views2 answers
Lerp c#
C#
0 vote193 views1 answer
Convert json to list object c#
C#
2 votes185 views2 answers
Binary tree
C#
0 vote284 views1 answer
Uncapitalize string c#
C#
0 vote185 views1 answer
Add variable to the beginning of a list c#
C#
0 vote181 views1 answer
C# handle dbnull value
C#