/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 vote170 views1 answer
Devexpress spreadsheet document source wpf
C#
4 votes224 views1 answer
Unity replace a text in a string
C#Unity
24 votes169 views1 answer
Csharp datetime string format
C#
0 vote242 views1 answer
Hovercraft in Unity
C#Unity
32 votes256 views4 answers
Raycasthit unity
C#Unity
0 vote278 views1 answer
C# underscore variable
C#
0 vote207 views1 answer
Exception e is null c#
C#
0 vote170 views1 answer
Exception meaning in .net core
C#
-2 votes376 views1 answer
Unity c# flip sprite
C#
4 votes223 views7 answers
Int
C#