/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 vote295 views1 answer
Vb.net read registry key as string
C#
1 vote310 views1 answer
C# verify in class exist in list
C#
0 vote334 views1 answer
Call Textboxfor in cs
C#
0 vote273 views1 answer
C# sharepoint get users from column
C#
2 votes300 views1 answer
How to replace string in c#
C#
0 vote275 views1 answer
Create a xml file with c# and use xmlwriter to write to class
C#
2 votes311 views1 answer
But dotnet-ef does not exist.
C#
0 vote316 views1 answer
Math.pow in C# using loop
C#
0 vote379 views1 answer
C# propertyinfo indexof
C#
0 vote367 views1 answer
Implementing Banner Ads Unity
C#Unity