OFFSET/FETCH support in EF 5.0 when using SQL Server 2012

Question

Hi,

Is there any chance to add support for OFFSET/FETCH in the upcoming EF 5.0, when using the ADO.NET provider for SQL Server 2012? 
Right now, as far as I can see in EF 5.0 beta1, still the old method which uses ROW_NUMBER/OVER is used when issues a ....Skip().Take() with SQL Server 2012 RC0..

(there is even a uservoice feedback for this missing feature: http://data.uservoice.com/forums/72025-ado-net-entity-framework-ef-feature-suggestions/suggestions/2541081-use-offset-and-fetch-for-take-and-skip-for-sql-ser ) 

Answer 1

Hi Tudor,

I'd like to help you to check it, thanks for understanding.

Have a nice day.

---

Alan Chen[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Thanks, but I'm not sure I understand what do you mean by 'I'd like to help you to check it' ..
I already checked, and in the current version of EF5 beta1 release on NuGet, the generated SQL uses the old method.
I was just asking if anybody knows if support for OFFSET/FETCH will be added in a future EF version.
I suppose the ADO.NET provider for SQL Server 2012 has to be modified for this.

Answer 3

So, it seems that nobody knows anything about this :( - maybe I should dig in the release notes for SQL Server 2012 maybe I discover something.. :)