title: nHibernate SetFirstResult & SetMaxResults Problems
body: <p>I am using nHibernate and trying to implement some paging. If I run this code</p>
  
  <pre><code>IList list = session.CreateQuery("FROM Author").List();
  </code></pre>
  
  <p>it returns 8 records. If I run this code though</p>
  
  <pre><code>IList list = session.CreateQuery("FROM Author")
      .SetFirstResult(1).SetMaxResults(5).List();
  </code></pre>
  
  <p>it returns 0 records. When I look at the SQL generated I can't see that there is any paging logic. </p>
  
  <p>What is the most likely errors with this?</p>