RepoDB
RepoDB copied to clipboard
Use FETCH NEXT over CTE ROW_NUMBER() when doing a BatchQuery.
Use this query instead.
SELECT *
FROM Table
ORDER BY Column1, Column2
OFFSET 13000000
ROWS FETCH NEXT 1000000 ROWS ONLY;
This must only affect the following classes.
- https://github.com/mikependon/RepoDb/blob/master/RepoDb/RepoDb/_SqlServer/StatementBuilders/SqlServerStatementBuilder.cs
- And all UnitTests
Note: Integration Tests must run as it is now.
Done in #1124