/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

10 votes245 views1 answer
Unity c# get bool from another script
C#
0 vote226 views1 answer
Unity set terrain to image
C#
0 vote274 views1 answer
Unity check if animator has parameter
C#Unity
-1 vote269 views3 answers
C# string with double quotes inside
C#
0 vote234 views1 answer
How to print text to screen in c#
C#
3 votes223 views1 answer
How do I print something in the console at the start of the game unity
C#
1 vote228 views1 answer
C# unity control key input
C#
0 vote227 views1 answer
Convert uk string date to DateTime c#
C#
0 vote281 views3 answers
For infinite loop c#
C#
4 votes223 views2 answers
Foreach c# linq example
C#