The task is to select all the records where parent equal ‘1’ and parent of parent equal ‘1’ etc. Our datatable is:
|
EntityId |
Name |
ParentId |
|
1 |
Dep1 |
0 |
|
2 |
Dep2 |
1 |
|
3 |
Dep3 |
1 |
|
4 |
Dep4 |
1 |
|
5 |
Dep5 |
2 |
