I want to return two result with one query. For instance the queried table and furthermore I want to return the size of the whole table.
I can not do it in c# because I only want to query for instance the first 100 results but it should be possible for the customer to query the next 100 results. But beforehand I want to show the customer if there are further results.
For instance I have a table with 150 results. In the first call I get only the first 100 results. But I also want to get the information that there are still 50 results left without calling a second query. Is this possible with dapper?
If you really just want to know IF there are more results and not how many, you could limit your results to 101. Then toss out the 101st row which is just an indicator that there is more than 100 rows.