阅读背景:

Can I retrieve paged rows and total count within a single query?

来源:互联网 

I have a basic grid with paging enabled in my web app. This grid is being populated by SQL data via a Web API using Dapper. In my API controller I am running two separate queries: one to extract the rows (which are shown in my grid), and one to obtain the total number of records (to show in my paging controls). And this works. However, I am trying to optimize my queries. I have a basic grid with paging enabled in my w




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: