BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

Entity Framework 5.0: Spatial Data Types, Performance Enhancements, Database Improvements

by Anand Narayanaswamy on Sep 10, 2012 |

Entity Framework 5.0 provides support for spatial data types and can be implemented using DbGeography and DbGeometry classes. It also introduces automatic compilation of LINQ to Entities queries by translating inline LINQ queries in a cached mode. Hence, developers need not have to make use of CompiledQuery.Compile method as in previous versions.

According to Entity Framework team at Microsoft, LINQ to Entities queries has improved the performance of applications by nearly 600% when compared with Entity Framework 4.0.

Entity Framework 5.0 automatically detects the database engine depending upon the development environment for the creation of new databases including the ability to make use of enum properties in entity classes. The framework also adds tables to the existing database if the target database doesn't contain any tables from the model.

The Entity Framework designer included with Visual Studio 2012 consist of new features such as DbContext code generation, multiple-diagrams per model, table-valued functions in addition to batch import of stored procedures which allows multiple stored procedures to be added during model creation. The new models created using the designer will generate a derived DbContext and POCO classes by default.

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

DBContext.CommandTimeout does not compile in .net 4.5 Entity framework 5. by Arne Garvander

This important feature must be hidden somewhere else. Where can I find it?

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT