[Solved] Issue regarding fetching data from DB using LINQ and .NET [closed]

by


Well you must have a foreign key for the parent.

Here is an example

select * from person parent
left join person child on child.Parent_ID = parent.ID
where parent.Name like 'Adam'

I think this should work for you, you could also left join the sub children of the sub children.

Or you can write query that search recursive.

Please see this article for more info

recursive-select

1

solved Issue regarding fetching data from DB using LINQ and .NET [closed]