static void Main(string[] args)

{

PersistenceManager pm = PersistenceManager.DefaultManager;

// Query orders in descending date sequence.

RdbQuery aQuery = new RdbQuery(typeof(Order));

aQuery.AddOrderBy(Order.OrderDateEntityColumn, System.ComponentModel.ListSortDirection.Descending);

// Build a paged query to retrieve 10 items at a time.

PagedRdbQuery pagedQuery = new PagedRdbQuery(aQuery);

pagedQuery.PageSize = 10;

pagedQuery.PagesShouldOverlap = false;

while (true) {

EntityList<Order> orders = pm.GetEntities<Order>(pagedQuery);

Console.WriteLine("Current page = " + pagedQuery.CurrentPage.ToString());

Console.WriteLine("Order count for this page = " + orders.Count.ToString());

foreach (Order anOrder in orders) {

Console.WriteLine(" Order id = " + anOrder.Id.ToString());

}

// to stop the window from going away

Console.WriteLine("\n\nPress Enter to continue");

Console.ReadLine();

if (pagedQuery.IsLastPage) break;

// Advance the query.