/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

1 vote285 views1 answer
Blank background for button wpf
C#
4 votes239 views3 answers
How to use onmousedown unity
C#
21 votes316 views8 answers
Translator
C#
0 vote278 views1 answer
C# restore form
C#
3 votes289 views1 answer
Unity know when mouse on ui
C#
0 vote298 views1 answer
Button commandfield commandargument pass textbox
C#
1 vote348 views1 answer
Reference to another script unity
C#Unity
0 vote291 views1 answer
C# downloadstirng download old
C#
2 votes313 views1 answer
How to restart flutter app programmatically
C#
1 vote280 views1 answer
.net: setting max size for sql parameter
C#