Entity Framework Code First and SQL Azure Connections
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 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.
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
链接地址: http://www.djcxy.com/p/15978.html上一篇: 我如何使用Entity Framework 4.2执行数据库迁移？
下一篇: 实体框架代码优先和SQL Azure连接