c# - Entity Framework Code First and SQL Azure Connections -
where can find sample of managing connection retries using sql azure , ef 4.1 code first dbcontext? have found plenty of information on should doing , why, here examples:
- http://blogs.msdn.com/b/sqlazure/archive/2010/05/11/10011247.aspx
- http://blogs.msdn.com/b/appfabriccat/archive/2010/10/28/best-practices-for-handling-transient-conditions-in-sql-azure-client-applications.aspx
- http://blogs.msdn.com/b/appfabriccat/archive/2010/12/11/sql-azure-and-entity-framework-connection-fault-handling.aspx
- http://social.technet.microsoft.com/wiki/contents/articles/1541.aspx
the trouble these refer objectcontext , can't figure out how make similar code work dbcontext without upsetting ef.
i not familliar code-first approach, know can instantiate dbcontext sql connection in constructor, use microsoft's customer advisory reliable sql connection implementation. connection has retry policy handles required retry logic need.
another option can do, implementation of dbcontext can implement retry logic on each call. again, check out cat team's implementation on how best that.
Comments
Post a Comment