/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 vote291 views1 answer
Unity random.insideunitcircle
C#Unity
0 vote288 views1 answer
Add qtwidgets to cmake file
C#
0 vote274 views1 answer
Raq query ef core
C#
0 vote342 views1 answer
Best programming language for compression ratio
C#
2 votes253 views2 answers
Making a list of chars in c#
C#
0 vote296 views1 answer
List of border roleplays roblox
C#
2 votes319 views1 answer
Camera follow player unity smooth
C#Unity
0 vote264 views1 answer
Get path revit linked unload
C#
0 vote282 views1 answer
Wpf how to focus on element
C#
1 vote266 views1 answer
Vb.net open file with default program
C#