Search code examples
ormlite-servicestack

Paging in servicestack ormlite

I am looking for a good way to implement paging in ormlite and I found another question, which has this snippet:

var data = db.Select<address>(predicate).Skip((int) pageNumber).Take((int) pageSize).ToList();

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.

At another google groups post 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?

Solution

  • Found the answer in ormlite's tests. Essentially we could use SqlExpressionVisitor's Limit() like this:

    var result = db.Select<K>( q => q.Where(predicate).Limit(skip:5, rows:10 ) );