Sunday, March 04, 2012 9:10 PM
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 )
Monday, March 05, 2012 8:44 AMModerator
Monday, March 05, 2012 10:13 AMThanks, 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.
Friday, March 16, 2012 12:40 PMSo, it seems that nobody knows anything about this :( - maybe I should dig in the release notes for SQL Server 2012 maybe I discover something.. :)