Editorial question67.4K views3,612 votes0 answers4,867 following
AI-generatedEF 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