/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 vote210 views1 answer
Tee into file
C#
0 vote212 views1 answer
Unity 2D how to make top-down look controller
C#
3 votes243 views2 answers
Unity Make a 2D object look at the mouse position
C#Unity
0 vote217 views1 answer
Asp.net issue
C#
1 vote214 views2 answers
C# singleton
C#
1 vote200 views2 answers
Dynamic arrays in c#
C#
0 vote195 views1 answer
Checkbox on change c# xamarin forms
C#
0 vote194 views1 answer
Beard styles without mustache Intitle:work with me
C#
0 vote278 views1 answer
Best programming language for compression ratio
C#
2 votes216 views1 answer
C# linq select from object list
C#