/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 views1 answer
C# restart app
C#
6 votes127 views2 answers
String interpolation in C#
C#
1 vote139 views1 answer
Unity how to move an object to another object
C#
2 votes123 views1 answer
C++ in C#
C#
3 votes114 views2 answers
C# array index tostring
C#
0 vote133 views1 answer
Move files from one folder to another using c#
C#
19 votes131 views2 answers
Unity reset scene
C#
0 vote119 views2 answers
C# list tuple
C#
5 votes105 views1 answer
Unity projectile spread
C#Unity
0 vote147 views1 answer
C# draggable controls
C#