/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 vote365 views1 answer
Difference between IHostingEnvironment and IWebHostEnvironment ?
C#
0 vote404 views1 answer
C# don't scroll up after onclick
C#
2 votes301 views1 answer
Unity ray from mouse position
C#
3 votes309 views2 answers
C# ienumerable to list
C#
0 vote319 views1 answer
IOS app crashing on ios 15 unity
C#
0 vote332 views1 answer
Rotate gameobject unity
C#
0 vote332 views1 answer
C# convert linq jValue to int
C#
0 vote347 views1 answer
Unity how to find the largest value out of 2 numbers
C#
0 vote263 views1 answer
How to set an expiry date on a program
C#
0 vote329 views1 answer
Is and as in c#
C#