Bring back support for UseRowNumberForPaging in EntityFrameworkCore 9.0/8.0. Use a ROW_NUMBER() in queries instead of OFFSET/FETCH. This method is backwards-compatible to SQL Server 2005.
Get Started
$ dotnet add package EntityFrameworkCore.UseRowNumberForPagingReadme
EntityFrameworkCore.UseRowNumberForPaging
Bring back support for UseRowNumberForPaging in EntityFrameworkCore 9.0/8.0/7.0/6.0/5.0
If you are using EntityFrameworkCore 5.0 please use version 0.2.
If you are using EntityFrameworkCore 6.0/7.0 please use version 0.5.
Usage
The same as original UseRowNumberForPaging method
optionsBuilder.UseSqlServer("connection string", i => i.UseRowNumberForPaging());