/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 vote281 views1 answer
Install Mono project on Ubuntu 20.04
C#
44 votes281 views5 answers
C# error messagebox
C#
0 vote320 views1 answer
Unity make particles stay still
C#Unity
0 vote262 views1 answer
Begininvoke async c#
C#
9 votes265 views6 answers
Remove character from string C#
C#
0 vote281 views1 answer
How do you search for how many times a character appears in user input on c sharp
C#
-1 vote263 views1 answer
C# datagridview select row index programmatically
C#
1 vote327 views1 answer
Hide button unity
C#Unity
0 vote310 views1 answer
How to convert int to char in c#
C#
2 votes273 views1 answer
C# math to radiant
C#