Offset/Fetch based paging (Implementation) in EntityFramework (Using LINQ) for SQL Server 2008

Question

Offset/Fetch based paging (Implementation) in EntityFramework (Using LINQ) for SQL Server 2008

entity-framework entity-framework-6 pagination sql-server sql-server-2008

Question

I am using SQL Server 2008 and Entity Framework 6.1.3. I wish to implement pagination of data based on OFFSET/FETCH rather than Take() & Skip().

I searched online with no luck. Some posts suggested migrating to SQL Server 2012. Which is not an option in my case.

Can someone suggest how to use OFFSET/FETCH with SQL Server 2008 and EF 6.1.3

Immortal

Related Questions

View more on Stack Overflow

DavidG · Accepted Answer · 7/25/2017 12:26:37 PM

This is possible with Entity Framework 6.1.2 and above so you should be OK to use it in your project. The standard Skip and Take methods can't be captured in the same way as others. There are now two additional overload of the Skip/Take methods that take lambdas, so instead of this:

var results = context.MyTable
    .Skip(10)
    .Take(5);

Do this:

var results = context.MyTable
    .Skip(() => 10)
    .Take(() => 5);

Offset/Fetch based paging (Implementation) in EntityFramework (Using LINQ) for SQL Server 2008

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Related Questions

Fastest Entity Framework Extensions

Performance

Expression Evaluator

Related