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.
I see in the developer's guide it mentions how to configure each of the modules. I think it might be beneficial to document how to turn off and remove modules properly.
As it stands we are going to:
It would be good to see documentation on how to perform this aspect correctly (and apologies if it is there already, I'm still reading through). If this already exists, it might be helpful to at least mention and link to it from the developer's guide.