/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 vote101 views1 answer
C# clamp
C#
0 vote146 views1 answer
Datatable iqueryable c# linq
C#
2 votes178 views1 answer
Fade text unity
C#Unity
2 votes177 views1 answer
Unity c# addition class
C#Unity
0 vote134 views1 answer
Top down movement unity
C#
2 votes172 views1 answer
C# compile code at runtime
C#
0 vote140 views1 answer
Bootstrap distane between col
C#
0 vote141 views1 answer
Save form in asp.net mvc
C#
13 votes160 views3 answers
C# get last item in list
C#
0 vote154 views9 answers
C# return error status code based on exception
C#