I tried making a criteria and I can do all filters until I get to a many-to-many.

Example:
Object A contains 0-to-n object Bs. How do you filter a list of objects where object A contains a specific object B using expressions.

I played around with HQL and got it working with HQL but I thought that this sort of thing would be really common and could be done with expressions which are easier to use when you have heaps of if-elseif-elseif-elseif-...

string hql =
"select wi " +
" from WorkItem wi " +
" join wi.Components as wic " +
" where wic.Id = :componentId";

If it cannot be done with expressions, would the HQL above be the right way to achieve this.

Thanks in advance, Jono

Just bumping this back to the top.

Since this is a pretty simple question I thought I would have received a reply. If you know the answer to my question I'd really like to hear from you because I can't continue with this section without an answer.

Thanks, Jono

I have worked it out, the copy of the NHibernate docs I have must be pretty old or I missed the associations section because the online on has the section. You just have to create a criteria under the criteria.

Here is what I am using now: