/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 vote189 views1 answer
For loop Stringbuilder c#
C#
2 votes139 views1 answer
Sconvert string to title case + C3
C#
0 vote171 views1 answer
How to run code without a gameobject unity
C#
0 vote210 views1 answer
Unity3d gameobject follow path
C#
4 votes198 views1 answer
Unity replace a text in a string
C#Unity
33 votes194 views2 answers
How to parse a string to an integer c#
C#
0 vote188 views1 answer
How to access a text gameobjceet in unity and change it
C#
1 vote181 views1 answer
Visual studio run multiple forms at once
C#
9 votes209 views2 answers
How to change textMesh Pro unity
C#Unity
0 vote182 views1 answer
How to return a list to view after foreach in c#
C#