Automatically perform retry logic for SQL Azure
Ideally, a simple IsSqlAzure=true in the connection string would have EF automatically implement SQL Azure retry logic under the hood. The current Microsoft recommendation requires wrapping every single DB query with more code, and is a very inefficient solution. Reference:
http://blogs.msdn.com/b/appfabriccat/archive/2010/12/11/sql-azure-and-entity-framework-connection-fault-handling.aspx
We are planning to do something like this to improve EF’s connection resiliency in EF6.
3 comments
-
Adam Pedley
commented
Certainly would solve a multitude of problems for myself and others.
For those new to this issue, here is some background: http://stackoverflow.com/a/12738879/540339
-
Matt
commented
This would really solve a lot of problems for my team. Any updates on this? It's the top feature for the "Azure" tag now... Thanks! Matt
-
Steve Harshbarger
commented
Support SQL Azure database out of the box. Doesn't work currently.