Parent – Child in recursive data table with LINQ
If you have a data table which looks like this one below and holds child,parent rows at the same table;
| ID |
ParentID |
Name |
| guid1 |
null |
parent 1 |
| guid2 |
guid1 |
child for parent 1 |
| so on |
so on |
so on |
and you wont to retrieve all records from the table in a table looks like below;
| Parent |
Childs |
| parent 1 |
child 1 for parent 1
child 2 for parent 1
child 3 for parent 1
…. |
| Parent 2 |
child 1 for parent 2
child 2 for parent 2
…. |
This means that i have to make a recursive query in Sql to retrieve it this way. but with LINQ its more easy to be done, see the query below;
1: var q= from p in TypedDataTable
2: where p.ParentID == null // well get all parents
3: select new
4: {
5: ParentID = p.ParentID,
6: child = from c in TypedDataTable
7: where c.ParentID == p.ID select
new {ChildID=c.ID,
8: ParentID = c.ParentID}
9: };
10:
and by the query above you’ll get this result;
NOTICE : this query will load one level at a time
hope this helps