/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 vote121 views1 answer
How to make soft body OBJECT in unity
C#
4 votes115 views4 answers
C# datagridview hide column
C#
8 votes117 views3 answers
Unity get component in parent
C#
0 vote126 views2 answers
Linear search c#
C#
1 vote113 views1 answer
Mvc select list order by
C#
0 vote115 views1 answer
Unity3d find y position on navmesh
C#
1 vote117 views1 answer
Copy text from a text box c#
C#
1 vote126 views1 answer
How to index ireadonlycollection c#
C#
0 vote128 views1 answer
Bitwise Left Shift C#
C#
1 vote165 views1 answer
C# append textbox
C#