/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

-2 votes359 views1 answer
How to move balance from one card to another target
C#
7 votes282 views2 answers
Insert variables into string c#
C#
0 vote258 views1 answer
.net core upgrade assistant
C#
0 vote231 views0 answer
C#
1 vote265 views1 answer
C# word randomizer
C#
0 vote275 views1 answer
Write last line txt file c#
C#
0 vote276 views1 answer
How prevent user remove file linux
C#
0 vote255 views1 answer
How to cut a string in c#
C#
0 vote299 views1 answer
C# chance of
C#
0 vote256 views1 answer
Detect keypress c#
C#