/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 vote145 views1 answer
Razor concatonate inline
C#
0 vote171 views1 answer
C# list to string replace last comma with and
C#
4 votes155 views1 answer
Deactivate a gameobject unity
C#
0 vote153 views1 answer
C# get all id of list object
C#
0 vote148 views1 answer
Unity run all interfaces
C#
0 vote182 views1 answer
C# string code ascii
C#
5 votes146 views1 answer
Loop over object properties c#
C#
10 votes148 views3 answers
Switch case in c# with multiple values
C#
0 vote190 views1 answer
C# calendar button random dates
C#
1 vote194 views1 answer
How to make int in c#
C#