/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 vote410 views1 answer
What is unity3D
C#Unity
0 vote331 views1 answer
Rock paper scissors c#
C#
-2 votes275 views1 answer
Tryparse string to int c#
C#
1 vote335 views1 answer
C# winforms input
C#
24 votes349 views3 answers
How to get an child of an gameobject
C#
0 vote359 views2 answers
C# boundingbox text
C#
0 vote320 views1 answer
Unity ar scale
C#Unity
2 votes340 views1 answer
Ef Select 2 from DB
C#
0 vote337 views1 answer
Convert string to short c#
C#
0 vote364 views1 answer
C# remove
C#