/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

1 vote141 views2 answers
C# catch two exceptions in one block
C#
3 votes191 views2 answers
Unity how to add force
C#Unity
0 vote151 views1 answer
C# test if char is alpha
C#
1 vote224 views1 answer
How to parent something unity
C#Unity
2 votes214 views1 answer
Unity return coroutine
C#Unity
1 vote146 views1 answer
Unity c# how to restart the level
C#
0 vote135 views1 answer
C# read GroupComponent using regex
C#
0 vote223 views1 answer
Fix diagonal movement unity
C#Unity
0 vote176 views1 answer
BindableDynamicDictionary
C#
11 votes189 views3 answers
Unity pick random number
C#Unity