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
– Robert Moore, Commented Jun 17, 2013 at 16:45

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

3

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.

answered Jul 4, 2011 at 8:25

Anže Vodovnik

2,3451 gold badge16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anže Vodovnik Over a year ago

On a side note, you can have a look at their SQL Connection Factory implementation as well, as you'll see in the link to MSDN blog, you can specify the connection factory as well, which is an even better pattern if you don't want to manage your own connections.

Generic Error · Accepted Answer · 2013-09-09 23:25:28Z

0

The upcoming Entity Framework 6 release now includes built in support for connection resiliency, see here for more details:

http://blogs.msdn.com/b/adonet/archive/2013/08/21/ef6-release-candidate-available.aspx https://entityframework.codeplex.com/wikipage?title=Connection%20Resiliency%20Spec

answered Sep 9, 2013 at 23:25

Generic Error

4,4776 gold badges32 silver badges26 bronze badges

Collectives™ on Stack Overflow

Entity Framework Code First and SQL Azure Connections

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related