Translate HQL to criteria?

rolandz · **Posted:** Sat Apr 19, 2008 2:48 pm

How do I translate the following query to the criteria query?

Code:

select distinct d from Document d
  inner join d.Categories
  where :category in elements(d.Categories)

rolandz · **Posted:** Sun Apr 20, 2008 2:48 am

In other words the question would look like:

How to create criteria that checks whether a given object (provided as parameter) is the one of associated collection in the persisted object.

More detailed: I have a persisted class (Document) that has associated collection of categories (DocumentCategory). Now I want to get documents that belong to given category.

rolandz · **Posted:** Sun Apr 20, 2008 7:47 am

I think I've found how to achieve that. It seems extreemly simple so please anybody verify me if possible. The solution criteria looks like the following:

Code:

ICriteria criteria = session.CreateCriteria(typeof(Document));
object result = criteria
  .CreateCriteria("Categories")
    .Add(Expression.IdEq(categoryId))
  .List<Document>();

BTW: Is looks much easier than in case of HQL...