To efficiently allow the display of large sets of data, Dapper.SimpleLoad needs support for the paging of result-sets within the database. TSQL supports several options for the paging of results. A simple method is to use the OFFSET FETCH clause, e.g.:
SELECT * FROM myTable ORDER BY SortColumn DESC OFFSET @offset ROWS FETCH NEXT @fetch ROWS ONLY
This enhancement request is to add support in Dapper.SimpleLoad for the following (or equivalent) parameters when executing a query:
SortColumn - the column to sort the results by
SortAscending - if true sort ascending, otherwise sort descending
Offset - the rows in the result-set to skip before returning results
Fetch - the maximum number of rows to return
Ideally support would be added for multiple levels of sorting. Dapper.SimpleLoad currently supports a desiredNumberOfResults parameter that restricts the number of rows a query returns using a TOP clause. It might be possible and desirable to overload this parameter to act as the Fetch parameter described above.
To efficiently allow the display of large sets of data, Dapper.SimpleLoad needs support for the paging of result-sets within the database. TSQL supports several options for the paging of results. A simple method is to use the OFFSET FETCH clause, e.g.:
SELECT * FROM myTable ORDER BY SortColumn DESC OFFSET @offset ROWS FETCH NEXT @fetch ROWS ONLY
This enhancement request is to add support in Dapper.SimpleLoad for the following (or equivalent) parameters when executing a query:
Ideally support would be added for multiple levels of sorting. Dapper.SimpleLoad currently supports a desiredNumberOfResults parameter that restricts the number of rows a query returns using a TOP clause. It might be possible and desirable to overload this parameter to act as the Fetch parameter described above.