Hello,

the docs state the following:

However, in SqlServerCompiler.cs public bool UseLegacyPagination is set to true by default. Per the docs this should not happen. I am going to address this in a PR.

Best,
Alex