Usually when I write repositories, I end up with code like this:

IList<Order> orders = repos.FindOrdersByStatus(OrderStatus.Packed);

One problem with this is that orders might contain 10,000 records, and I don’t really want to pull all that back from the database in one go. What I think I want is this:

IList<Orders> orders = repos.FindOrdersByStatus(OrderStatus.Packed)
                                                  .Skip10)
                                                  .Take(10)
                                                  .ToList();

Is anyone doing this?