title: Paging in servicestack ormlite
body: <p>I am looking for a good way to implement paging in ormlite and I found another <a href="https://stackoverflow.com/questions/15705419/passing-params-expression-results-in-strange-error">question</a>, which has this snippet:</p>
  
  <p><code>var data = db.Select&lt;address&gt;(predicate).Skip((int) pageNumber).Take((int) pageSize).ToList();</code></p>
  
  <p>Problem with the above is that it gets back all the results and then does the skip and take on it which defeats the purpose of paging.</p>
  
  <p>At another <a href="https://groups.google.com/forum/#!topic/servicestack/fcObh8Nn2x8" rel="nofollow noreferrer">google groups post</a> I have found the same problem and a sample in a github issue is mentioned as a solution but the URL no longer works. Does anyone know how to correctly page using servicestack?</p>