Hi. I need to implement searching in product catalog. For example I have 2 classes:

class Category
{
public int Id; public Category Parent; public String Name; public IList ChildCategories;
}

class Product
{
public int Id; public String Name; public Category Category;
}

How to retrieve products in category which id I know and products in all child categories with infinity nesting.

Ex: query like: "select from Product p where p.Category.Id = 5 and p.Name like '%hiber%'" - it will retrieve products only in category with id = 5. But how to retrieve products in all child categories?