/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 vote251 views1 answer
Monegame deltatime
C#
0 vote306 views3 answers
For infinite loop c#
C#
0 vote266 views1 answer
T SQL Format GetDate()
C#
0 vote258 views1 answer
How to make a simple console select screen using C# ReadKey
C#
3 votes247 views2 answers
C# windows grab screenshot
C#
0 vote272 views1 answer
One to many relationship in asp net entity framework with role
C#
32 votes271 views4 answers
How to print using C#
C#
0 vote302 views7 answers
C# USING SHARED CLASS
C#
20 votes271 views6 answers
Random number generator
C#
0 vote279 views1 answer
The terminal process failed to launch: Path to shell executable "dotnet" is not a file or a symlink.
C#