Building Custom Paging with LINQ,ListView,DataPager&ObjectDataSource

Custom paging is required by many application, and is implemented with different approaches. The approach represented here is using LINQ to SQL to construct database paging query. It is not the best, but it is effective because using this method you can custom paging and sorting with generic method. So you don't have to create stored procedure of each table you wish to page through.