/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 vote169 views1 answer
Csharp functions
C#
0 vote158 views1 answer
Windows forms add onclick
C#
0 vote170 views1 answer
C# sprintf equivalent
C#
0 vote167 views1 answer
Commit help
C#
3 votes169 views3 answers
C# list of properties from list of objects
C#
1 vote181 views1 answer
Lat long data type c#
C#
2 votes249 views1 answer
Camera follow player unity smooth
C#Unity
0 vote170 views1 answer
Calculate textbox value c#
C#
0 vote173 views1 answer
C# create default instance of type
C#
0 vote172 views1 answer
Formula resto divisão c#
C#