I've previously done paging both with the built in portion of asp.net as well as using row_number() in mssql 2005. The benefit of doing it in .net is that is incredibly easy to set up both sorting and ...

Take advantage of stored procedures, query pagination, query caching, and other advanced Dapper feature to simplify data access and ensure high performance. The Dapper ORM (object-relational mapper) ...