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

i using sql server 2008 , entity framework 6.1.3. wish implement pagination of data based on offset/fetch rather take() & skip().

i searched online no luck. posts suggested migrating sql server 2012. not option in case.

can suggest how use offset/fetch sql server 2008 , ef 6.1.3

this possible entity framework 6.1.2 , above should ok use in project. standard skip , take methods can't captured in same way others. there 2 additional overload of skip/take methods take lambdas, instead of this:

var results = context.mytable     .skip(10)     .take(5); 

do this:

var results = context.mytable     .skip(() => 10)     .take(() => 5);