There is a problem with Nhibernate, when paging record sets, using SQLServer. This offers a work around, to fix this problem.