/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

3 votes178 views1 answer
Create line in unity
C#Unity
3 votes136 views1 answer
Check ping c sharp
C#
0 vote125 views1 answer
Two question marks together mean in C#
C#
0 vote156 views1 answer
C# signalr console app client example
C#
0 vote139 views1 answer
Non null array length
C#
0 vote129 views1 answer
Htmlgenericcontrol class c#
C#
0 vote152 views1 answer
How to redirect to extern page in .net core
C#
0 vote135 views1 answer
Bootstrap distane between col
C#
0 vote138 views1 answer
HtmlToPdfConverter
C#
3 votes200 views1 answer
Unity c# on trigger enter with specific gameobject
C#Unity