SQL Azure and Entity Framework Connection Fault Handling

  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.  SQL Azure is a cloud-based database…

10

Disaster Recovery for AppFabric Caching configuration DB (SQL Mirroring)

  In the middle tier AppFabric (AF) Caching can be setup in High Availability (HA) mode which is the feature that improves resiliency in the case a cache server goes down and for the backed, when using SQL for your configuration database, the simplest answer is to use mirroring. You may use SQL cluster but…

0

Updating AppFabric Cache via SQL Service Broker External Activator

 Event Driven Updates If I can’t have magic then I want something easy. I’d like to have changes that occur on certain tables be reflected in AppFabric Cache. I’d also like this to occur in an event based manner.  “Use SqlDependency and be done with it” you say? That’s certainly one answer but it also creates…


Solving the “No logical space left to create more user strings” Error and Improving performance of Pre-generated Views in Visual Studio .NET4 Entity Framework

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 large complex models that consist of many entities and associations), can create lots…

1

Potential Performance Issues with Compiled LINQ Query Re-Compiles

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 in caching the resulting database command from…

0

Profiling Entity Framework using the Visual Studio 2010 Profiler

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 the previous blog will be used as…

0

Epicor Visual Studio 2010 Entity Framework Case Study Posted

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 4 to ease development and reduce SQL Server…

0

Isolating Performance with Precompiled/Pre-generated Views in the Entity Framework 4

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). When working with Entity Framework 4 one of the potential optimizations is…

6