locked
EF 5 and SQL Server 2012 paging RRS feed

  • Question

  • Hello,

    Does Entity Framework 5 has any extension for the new SQL Server 2012 paging?

    SELECT * FROM [Posts]
    ORDER BY [InsertDate]
    OFFSET 20 ROWS
    FETCH NEXT 5 ROWS ONLY

    When will EF 5 be released? Any idea?

    Thank You,

    Miguel

    Thursday, March 29, 2012 9:21 AM

Answers

  • Hi MDMoura,

    Welcome to MSDN Forum.

    Below are all the updates in EF5, is seems have no such a extension method. EF5 beta2 has already avalaible on NutGet.

    What’s New in EF5?

    EF 5 includes bug fixes to the 4.3.1 release and a number of new features. Most of the new features are only available in applications targeting .NET 4.5, see the Compatibility section for more details.

    • Enum support allows you to have enum properties in your entity classes. This new feature is available for Model, Database and Code First.
    • Table-Valued functions in your database can now be used with Database First.
    • Spatial data types can now be exposed in your model using the DbGeography and DbGeometry types. Spatial data is supported in Model, Database and Code First.
    • The Performance enhancements that we recently blogged about are included in EF 5 Beta 1.
    • Visual Studio 11 includes LocalDb database server rather than SQLEXPRESS. During installation, the EntityFramework NuGet package checks which database server is available. The NuGet package will then update the configuration file by setting the default database server that Code First uses when creating a connection by convention. If SQLEXPRESS is running, it will be used. If SQLEXPRESS is not available then LocalDb will be registered as the default instead. No changes are made to the configuration file if it already contains a setting for the default connection factory.

    The following new features are also available in the Entity Model Designer in Visual Studio 11 Beta:

    • Multiple-diagrams per model allows you to have several diagrams that visualize subsections of your overall model.
    • Shapes on the design surface can now have coloring applied.
    • Batch import of stored procedures allows multiple stored procedures to be added to the model during model creation.

    Best Regards


    Allen Li [MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Allen_MSDN Thursday, April 5, 2012 2:09 AM
    Monday, April 2, 2012 1:49 AM