Is there any way to write LINQ (or with procedural style) query, that can select all children with one SQL query?
I have entity:
I have a ID, so I want to select Comment with ID and all its children with subchildren.
If ID == 1 then I want list of 1,2,3,4,5,6.
some SQL dialects have extensions for recursive queries, but this is not supported by DataObjects.Net
Generally if you are going to have good performance it's better to implement some tree storage pattern such as materialized path.
answered Nov 22 '12 at 03:37