Time for action – paging a query's results

Now let's take a look at how to implement paging in RavenDB. You will add two new methods to the Program class: the first one will query the Countries collection using Skip() and Take() methods, the second one will display the query's result pages.

1. Start Visual Studio and open the RavenDB_Ch05 solution.

2. Add the following code to the Main() method in the Program class:

   

3. Save all the files, build and run the solution.

What just happened?

We just queried the Countries Collection and implemented paging on the query result. By design RavenDB limits the number of returned documents to the client to 128 no matter how many there actually are.

In the code snippet (line 121), we declare a RavenQueryStatistics field to hold the output of the Statistics extension method, which will allow you to read the number of TotalResults.

While the only thing we wanted to do is to get the document count. So making Take(0) call will explicitly tell RavenDB not to load any entities...