I had some difficulty finding a good example of SetResultTransformer for an ICriteria for NHibernate. Here's a good one that helped me. Also has a good example of using aliases. I get confused when working with the semantics of ICriteria but it is really quite powerful for creating dynamic queries.