Where does paging, sorting, etc go in repository pattern?

Question

Where do we put the logic for paging and sorting data in an asp.net repository pattern project?

Should it go in the service layer or put it in the controller and have the controller directly call the repository? Controller -> Repository is shown here for a jquery grid.

But unlike that article, my repository returns IQueryable<datatype>

Answer 1

It should go in the Repository if your Repository returns materialized sequences (ICollection<T>, List<T>), etc.

But if your returning IQueryable<T> (like i am), i hope you have a service layer mediating between your Controllers and Repository, which executes queries on the IQueryable and materialises them into concrete collections.

So, i would put the paging in the service layer.

Something like this:

public PagedList<T> Find(Expression<Func<T,bool>> predicate, int pageNumber, pageSize)
{
   return repository
             .Find()
             .Where(predicate)
             .ToPagedList(pageNumber, pageSize);
}

.ToPagedList can be an extension method that applies the paging you require and projects to a PagedList<T>.

There are many PagedList<T> implementations out there. I like Rob Conery's one. Has properties that your View requires, so you can bind to a PagedList<T> and create a HTML Helper to render out the page numbers very easily. The only problem with any paged list LINQ implementation is the Count() operation (for the number of records) needs to be done on the server and hence results in 2 round trips.

You don't want to be returning non-materialized queries to your View's, as IMO this breaks the MVC pattern.

Each time you go to a new page, call your service to retrieve the required result.