/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

2 votes177 views2 answers
Inactive after active with press key unity
C#Unity
1 vote129 views1 answer
C# mongodb update multiple fields
C#
0 vote132 views2 answers
Euler to quaternion
C#
1 vote283 views1 answer
C# making a folder wpf
C#
0 vote160 views1 answer
[1], [2], [3]
C#
0 vote125 views1 answer
Net use delete
C#
0 vote135 views1 answer
C# print all properties of an object including children objects
C#
0 vote175 views1 answer
Handling aggregation responses with NEST c#
C#
0 vote135 views1 answer
How to lerp a value in unity
C#
0 vote129 views1 answer
Nethereum check gas price
C#