/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 vote192 views1 answer
How to pass optional guid parameters in c#
C#
0 vote186 views1 answer
How to add a ddos api to a c# console app
C#
0 vote192 views2 answers
How to convert list of string to single string in c#
C#
0 vote207 views1 answer
Project mongodb c#
C#
0 vote210 views1 answer
Restart animation unity
C#Unity
1 vote289 views1 answer
Unity c#loading a scene after a few seconds
C#Unity
0 vote199 views2 answers
Sorting list by date time dec in c#
C#
3 votes195 views1 answer
Tinyint in c#
C#
3 votes219 views1 answer
Unity look at target
C#Unity
1 vote209 views1 answer
Code jokes
C#