I am having an issue with Nhibernate returning no records (i am pretty sure it's not even hitting the database) when SetFirstResult(0) is set and i have a SetMaxResults(10) set. When I use SetFirstResult(1).SetMaxResults(10), i get records 2-11 from the database.

Any help is appreciated. I added a question on stackoverflow with some more detail and the code that i am using.

http://stackoverflow.com/questions/4832 ... -is-also-s

Thanks,
Brad

After going back and looking at this issue, i figured out what happened. I noticed that NHibernate was actually throwing an error. The message was "The query should start with 'SELECT' or 'SELECT DISTINCT". The first answer in http://stackoverflow.com/questions/2461 ... sqldialect solved my problem. I had to set use_sql_comments to false in my config file.