EF5 Performance Considerations

Over the past few weeks the EF team has been putting together a whitepaper that talks about the performance considerations developers should take when using Entity Framework. Performance is one critical aspect of developing modern applications, and this document will help developers make informed design decisions and get the most out of their applications when… Read more

Sneak Preview: Entity Framework 5.0 Performance Improvements

An O/RM, like any layer of abstraction, introduces overhead to data access. In EF 5.0 we have taken steps to reduce this overhead and improve performance. As a result in one of our tests, repeat execution time of the same LINQ query has been reduced by around 6x. We also have an end-to-end application that… Read more

Generated SQL Improvements for TPT Queries (June CTP)

  The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF.   Last year we wrote about some performance considerations when using TPT inheritance in the Entity Framework.  We are pleased to announce that with the Microsoft Entity Framework June 2011 CTP we… Read more

Entity Framework Improvements in Visual Studio 2010 SP1

The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. Today’s release of Visual Studio 2010 SP1 includes several performance and stability improvements for Entity Framework 4.0.  MSDN subscribers can download the service pack immediately, and the release will have general availability on… Read more

Managing Connections with SQL Azure and Entity Framework

The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. For using EF with SQL Azure see http://msdn.com/data/jj556244 The Windows Server AppFabric Customer Advisory Team recently put together some great guidance on managing connections with SQL Azure and EF.  They outline common connection… Read more

Connecting to SQL Azure using Entity Framework

The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. For using EF with SQL Azure see http://msdn.com/data/jj556244 The Entity Framework provides a very powerful way to access data stored in the cloud, particularly in SQL Azure.  Over the past month the SQL… Read more

Inheritance Mapping: A Walkthrough Guide for Beginners

  The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. For TPT Inheritance see http://msdn.com/data/jj618293 For TPH Inheritance see http://msdn.com/data/jj618292   Entity Framework’s Inheritance Mapping allows developers to map their classes to different database structures in order to fulfill their specific performance, extensibility,… Read more

Data Access Guidance

When considering how your application will connect to a data source, there’s a variety of technologies, patterns, and architectures to consider.  Recently we published a “Summary of Data Access Guidance” on the MSDN Data Developer Center.  If you want to drill deeper into the material, please check out Shyam Pather’s TechEd talk: Data Development GPS:… Read more

Performance Considerations when using TPT (Table per Type) Inheritance in the Entity Framework

  The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. For Performance Considerations see http://msdn.com/data/hh949853   The Entity Framework offers very rich inheritance mapping schemes for building your conceptual model. The inheritance capabilities in EF include: ·         TPH (Table per Hierarchy): This… Read more

Performance Impact of Server-side Generated GUIDs in EF

  The information in this post is out of date. Visit msdn.com/data/ef for the latest information on current and past releases of EF. For Performance Considerations see http://msdn.com/data/hh949853   Background EF4 supports the use of server-generated GUIDs, which has been a popular request since EF 3.5. Lee Dumond summarized his experience on how to use this feature… Read more