Recursive/Hierarchical query

[DevelPh]

Is there any way to select an item id and all its children ids with one query?

I have entity:

public class Comment
{
   public int Id {get;set;}
   public int ParentId {get;set;}
   public int Text {get;set;}
}

I have an ID, so I want to select Comment with ID and all its children with subchildren. Example:

1
-2
--3
-4
-5
--6
2
3

If ID == 1 then I want a list of 1,2,3,4,5,6.

I want to avoid using mulitple gets to achieve this result.

Grtz and thanks in advance,

Philippe Devel

philippe.devel@digipolis.be