C# Lambda Entity Framework: Any way to use a predicate Lambda to choose records by row number?

Question

I want to do paging outside of my Repository, but the Repository returns IList. Since I don't want to pull data unnecessarily, and don't want to create specific Paging methods in my Repositories, Is there any way to filter records by page in the Where extension method?

I want to do something like:

var myRecords = ProductRepo.Get( p => p.Name.StartsWith("Pepsi") &&
                                      p.Row_Number() > 9 &&
                                      p.Row_Number() < 21);

The Get repository code (doesn't handle row number of course):

public IList<Product> Get( Expression<Func<Product, bool>> filter = null)
{
    if( filter == null)
        return _dc.Products.ToList<Product>();
    else
        return _dc.Products.Where(filter).ToList<Product>();
}

Answer 1

Like that?

var myRecords = ProductRepo.Get( p => p.Name.StartsWith("Pepsi") ).Skip(9).Take(12);

Answer 2

Return IQueryable from your Repository (don't call .ToList()). You will be able to use Skip and Take then.

ROWNUM is not supported in EF.

http://social.msdn.microsoft.com/forums/en-US/adodotnetentityframework/thread/055911ff-6db6-48cb-8e50-bd6415b7eefe/