Nested CreateCriteria ‘gotcha’ when using NHibernate

Be careful when using nested .CreateCriteria because you may be generating and running more sql command than you thought. Take a look at how to tweak your code to prevent this issue.