Paging, Sorting, and Searching in ASP.NET MVC using PagedList and Dynamic Linq

PagedList.mvc is a lightweight API for server side paging in ASP.NET MVC. The only thing we want to avoid is reading all the records from the database and let the PagedList display the records by page. Obviously it's a bad design. What we want to achieved is to read and display the records per page.