/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

8 votes341 views2 answers
C# add object to array
C#
0 vote354 views1 answer
Js if empty then 0
C#
3 votes334 views1 answer
C# writeline
C#
1 vote349 views1 answer
C# method returns multiple values
C#
2 votes405 views2 answers
Inactive after active with press key unity
C#Unity
2 votes341 views2 answers
HCF of number
C#
0 vote341 views1 answer
Getname of month from date c#
C#
0 vote389 views3 answers
Ddsfsd
C#
0 vote394 views1 answer
Gravity script unity
C#Unity
0 vote360 views1 answer
Hide external app from taskbar
C#