A number of customers are choosing to use Entity Framework with Microsoft SQL Azure , and rightfully so. Entity Framework provides an abstraction above the database so that queries are developed using the business model or conceptual model and queries are executed using the richness of LINQ to Entities...

The title lends itself to a bit thought.  Why would the developer feel the need hold a static reference to the MetadataWorkspace of an Entity Framework (EF) model from within their WCF service-oriented applications?  The premise being that the WCF services are using EF to serve up data from...

T4 background Leveraging the power of Text Template Transformation Toolkit (T4 template) to generate code (or any other type of text) is a great time saver and it is particularly useful when working with Entity Framework (EF) since it allows to easily (almost in a batch like fashion) do things like...

As shown in the previous precompiled view blog ( Isolating Performance with Precompiled/Pre-generated Views in the Entity Framework 4 ), views can significantly improve performance in various scenarios such as first-run; memory usage; and execution of one-off queries. However, the creation of views for...

When calling a query multiple times with Entity Framework the recommended approach is to use compiled LINQ queries. Compiling a query results in a performance hit the first time you use the query but subsequent calls execute much faster. The CompiledQuery class has functionality to compile and assist...

A previous post discussed potential issues with Compiled Query recompiles. The cause of the recompile issues were actually uncovered by using the Visual Studio 2010 Profiler . This blog will cover how the Profiler can be used to discover performance issues in the Entity Framework. The sample code from...

Check out the Epicor Case Study that was recently published by one of our partners. Epicor is a global software company that creates enterprise resource planning (ERP) solutions for manufacturing firms and other customers. They have been able to leverage Visual Studio 2010 and ADO.NET Entity Framework...

Introduction Working with customer’s solutions, we often have to track down potential performance issues or uncover areas for improvement. One of the techniques is to try and measure the relative performance gained using the different configurations or features (likely in a staging/testing environment...