https://github.com/aspnetzero/aspnet-zero-core/issues/3287
For SQL Server 2008, what I've done is the following:
builder.UseSqlServer(connectionString);
and
builder.UseSqlServer(connection);
to
builder.UseSqlServer(connectionString, s => s.UseRowNumberForPaging());
and
builder.UseSqlServer(connection, s => s.UseRowNumberForPaging());
See [https://github.com/aspnet/EntityFrameworkCore/issues/4616#issuecomment-221331425]) for details.