Ashraf Moollan's Blog

This is a simple solution on how to get data in chunks from a WCF service (e.g. a paged list of results)

Assuming that your service pulls data from a SQL Server database, you can use Linq2Sql and create your data context, OR if you are not using SQL Server, then the Microsoft Entity Framework may suit you.

Here is the code:

public IList <customers> GetCustomers(int pageIndex, int pageSize, out int total)
 {
  using (var db = new NorthwindDataContext())
    {
     var customers = db.Customers;
     total = customers.Count();
     var results = customers
      .Skip(pageIndex * pageSize)
      .Take(pageSize);
     return results.ToList();
    }
 }