/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 vote319 views1 answer
Why Duplicate "..TargetFrameworkAttribute" c# assemblies created
C#
2 votes292 views1 answer
C# shuffle string array
C#
16 votes261 views1 answer
For loop on enum c#
C#
1 vote301 views3 answers
Get key in dictionary c#
C#
0 vote299 views1 answer
.net core authorizationhandlercontext
C#
1 vote315 views1 answer
C# convert int to pretty string
C#
38 votes361 views3 answers
C# console delete last character
C#
0 vote313 views1 answer
Unity PlayOneShoot Audio
C#
0 vote310 views1 answer
How to start commvault services on linux
C#
0 vote361 views1 answer
Unity FPS camera z axis rotating problem
C#Unity