NHibernate many-to-many criteria

[bigmerf]

I have a list of questions, each linked to a list of tag.And the following data : \[code\]Question1 : Tag1Question2 : Tag1, Tag2Question3 : Tag1, Tag2, Tag3Question4 : Tag1, Tag3\[/code\]The following criteria :\[code\]var tagsIds = new int[] { tag1, tag2 };var res = session.CreateCriteria<Question>() .CreateCriteria( "Tags" ) .Add( Restrictions.In( "id", tagsIds ) ) .List<Question>();\[/code\]returns (I understand why, the "in" acts like an OR)\[code\]Question1, Question2, Question3, Question4\[/code\]Or I would like to get only\[code\]Question2, Question3\[/code\]as they both have tag1 AND tag2.I there a way to do it ?In SQL, I would do something like :\[code\]SELECT *FROM Question qWHERE EXISTS ( SELECT * FROM QuestionsToTags qtt WHERE qtt.Question_id = q.Id AND qtt.Tag_id IN ( 1, 2 ) GROUP BY qtt.Question_id HAVING COUNT( qtt.Question_id ) >= 2 )\[/code\]