/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

17 votes172 views2 answers
Visual studio c# print to console
C#
0 vote229 views2 answers
Remove all non alphabetic characters from string c#
C#
32 votes195 views4 answers
How to get keyboard input in unity
C#Unity
-1 vote138 views1 answer
Tsql list tables
C#
1 vote211 views1 answer
Change size of a unity object
C#Unity
0 vote174 views1 answer
C# decimal with two places store as string with two places
C#
6 votes179 views1 answer
Asp.net core entity framework database first
C#
0 vote159 views1 answer
Minimize window windows forms application c#
C#
0 vote170 views1 answer
Unity roam, chase, attack states
C#
0 vote194 views1 answer
Func<IDataRecord, T> c#
C#