Entity Framework Code First and SQL Azure Connections

Question

Where can I find a sample of managing connection retries using SQL Azure and EF 4.1 Code First DbContext? I have found plenty of information on what I should be doing and why, here are some examples:

The trouble with these it they all refer to ObjectContext and I can't figure out how to make similar code work for my DbContext without upsetting EF.

I've created a library which allows you to configure Entity Framework to retry using the Fault Handling block without needing to change every database call - generally you will only need to change your config file and possibly one or two lines of code. This allows you to use it for Entity Framework or Linq To Sql. github.com/robdmoore/ReliableDbProvider — Robert Moore

Anže Vodovnik Anže Vodovnik · Accepted Answer · 2011-07-04T08:25:10

I am not that familliar with Code-first approach, but I do know you can instantiate the DbContext with a SQL Connection in the constructor, you could use Microsoft's Customer Advisory Reliable SQL Connection implementation. This connection has a Retry Policy that handles all the required retry logic you need.

Another option you can do, your implementation of the DbContext can implement the retry logic on each call. again, check out the CAT team's implementation on how to best do that.

Entity Framework Code First and SQL Azure Connections

2 Answers