/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

8 votes242 views2 answers
Float to int c#
C#
0 vote205 views1 answer
Select from oracle in c#
C#
0 vote263 views1 answer
Allow edit in Datagrid C#
C#
7 votes243 views1 answer
How to convert string to guid c#
C#
0 vote230 views1 answer
Crystal reports convert decimal to integer in formula
C#
23 votes255 views2 answers
Unity no serializefield
C#Unity
1 vote211 views1 answer
C# using file.io
C#
1 vote237 views2 answers
Merge xml files into one c#
C#
0 vote243 views1 answer
Implement custom string to datetime convert net core
C#
0 vote233 views1 answer
Ssml
C#