/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

4 votes234 views2 answers
Check if gameobject exists unity
C#
0 vote232 views1 answer
Wpf keyboard press event
C#
1 vote184 views1 answer
Wpf data context
C#
0 vote217 views1 answer
C# create monochrome bitmap
C#
0 vote207 views1 answer
C# condition and
C#
6 votes224 views2 answers
Checking a gamobjects layer
C#
0 vote291 views1 answer
C# WPF Timer
C#
4 votes210 views1 answer
ALWAYS MAximize window on start c#
C#
4 votes220 views1 answer
Convert timestamp to datetime c# code
C#
0 vote209 views1 answer
C# param exception
C#