EF Core Skip/Take pagination changes SQL translation across SQL Server compatibility boundaries
Entity Framework Core translates Skip and Take into provider-specific SQL, but the exact translation depends on the database compatibility level. On SQL Server, a Skip/Take query typically becomes OFFSET ... ROWS FETCH NEXT ... ROWS ONLY on SQL Server 2012 or a compatible compatibility level; older instances may produce a different SQL shape. This creates a
entityframeworkcore