nhibernate « Criteria « JPA Q&A

1. How write hibernate criteria for specific SQL?    stackoverflow.com

i need write similar SQL by ICriteria: Tables: 1Lvl -- 2Lvl -- 3Lvl SQL:

SELECT * FROM 2Lvl
WHERE 2Lvl.1LvlFK in
(
    SELECT 1Lvl.Id

    FROM 3Lvl 

    JOIN ...

2. Criteria parsing method    stackoverflow.com

I have this method, receive a list of integer, and must return an Collection of EmployeeComments, the problem is I don't know how take each result of the criteria and Add ...

3. Return TSubType from nhibernate QueryOver    stackoverflow.com

I am trying to select the children from a parent collection using QueryOver in nhibernate. This is what I am trying to do in HQL:

SELECT as_kitten FROM Cat as_Cat 
JOIN as_Cat.Kittens as_kitten ...

4. NHibernate Futures vs CreateMultiCriteria    stackoverflow.com

I have used both NHibernate Futures and NHibernate CreateMultiCriteria in the past to batch sql queries. Are there any reasons why I would want to use one or the other. ...

5. NHibernate Many to Many Criteria Task Tag Example    stackoverflow.com

I have a simple many to many relationship set up between tasks and tags. A task may have many tags and a tag may be assigned to many tasks. I use ...