/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

-1 vote133 views4 answers
Signalr
C#
0 vote137 views1 answer
Unity mousetoterrainposition
C#
6 votes143 views1 answer
Unity call function on animation finish
C#
4 votes197 views1 answer
Unity new vector3
C#Unity
0 vote183 views5 answers
Linq cheat sheet
C#
0 vote128 views2 answers
Scaffold db
C#
0 vote149 views1 answer
What is void onmousedown()
C#
20 votes136 views1 answer
How to write switch statement unity
C#
3 votes167 views1 answer
Invoke once on update unity
C#Unity
0 vote123 views3 answers
Finding holydays asp.net
C#