New in Entity Framework 5

New in Entity Framework 5

What is New in Entity Framework 5 ?

    1. Enum Support 

             - allows you to have enum properties in your entity classes (await for next post ...)

    2. Spatial Data Types

             - can now be exposed in your model using the DbGeography and DbGeometry

               data types (await for next post ...)

    3. Performance Enhancements

        i. LINQ to Entities Query Repeat Execution Time

           - repeat execution time of the same LINQ query has been reduced by around 600%

           - by using automatic compilation of LINQ to Entities queries

                    What is automatic compilation ?

                         - now every LINQ to Entities query that you execute automatically

                           gets compiled and placed in EF’s query cache

                         - each additional time you run the query, EF will find it in its query cache

                            and won’t have to go through the whole compilation process again

                    Behind the scene of Auto-Compiled Query Process in EF 5

               Performance gain of EF 5 Hence Auto-Compiled Query Process

           

        ii. End-to-End Performance

                - performance tests that run a variety of operations designed to simulate the

                   typical usage a real-world application

                - then 67% performance increase over EF 4

                - just by upgrading the server to EF 5

"We aren’t done improving performance yet, but we’re excited about how much faster EF 5.0 is"

- The Microsoft Entity Framework Team

     4. Code First will now detect if you have LocalDb available for creating new databases

             - visual studio 2012 includes LocalDb

                     What is LocalDb ?

                        - Microsoft SQL Server 2012 Express LocalDB is an execution mode

                          of SQL Server Express targeted to program developers

                        - LocalDB installation copies a minimal set of files necessary to start the

                          SQL Server Database Engine

     5. Code First will add tables to existing database

            - if the target database doesn’t contain any of the tables from the model

What is New in Entity Framework Designer in Visual Studio 2012 ?

     1. DbContext code generation for new models

           - means that any new models created using the EF Designer will generate

              a derived DbContext and POCO classes by default

           - you can always revert to ObjectContext code generation if needed

           - existing models will not automatically change to DbContext code generation

     2. Multiple-diagrams per model

           - allows you to have several diagrams that visualize subsections of your overall model

           - shapes on the design surface can also have coloring applied

     3. Table-Valued functions

           - in an existing database can now be added to your model

     4. Batch import of Stored Procedures

          - allows multiple Stored Procedures to be added to the model during model creation

How to Install Entity Framework 5 for Visual Studio 2012 Solution ?

Step 1. Open Visual Studio 2012 with Your project

Step 2. Right Click Your Solution and then Click Properties

Step 3. Double check whether Your Target Framework is 4.5

Step 4. Right Click Your Solution and then Click Manage NuGet Packages... 

Step 5. Click Online Tab and Then Type Entity Framework 5 on Search Box

            After that Select EntityFramework and Click Install 

Step 6. Click I Accept

Step 7. Finally, Close the Manage NuGet Packages Screen

That's It.You're Done.

Conclusion

• You saw that how much of performance gain could be achieved by just updating the Application Server for Entity Framework 5 Out of the box without doing anything to your existing Linq to Entity Queries
• It's Simply Amazing
• So Try to use EF 5 with your projects and Enjoy it

I hope this helps to You.Comments and feedback greatly appreciated.