{"action":"created","issue":{"url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/3221","repository_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate","labels_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/3221/labels{/name}","comments_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/3221/comments","events_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/3221/events","html_url":"https://github.com/aspnetboilerplate/aspnetboilerplate/issues/3221","id":307799146,"number":3221,"title":"Azure SQL Database, EF Core EnableRetryOnFailure, and Connection Resiliency","user":{"login":"beriniwlew","id":11966374,"avatar_url":"https://avatars1.githubusercontent.com/u/11966374?v=4","gravatar_id":"","url":"https://api.github.com/users/beriniwlew","html_url":"https://github.com/beriniwlew","followers_url":"https://api.github.com/users/beriniwlew/followers","following_url":"https://api.github.com/users/beriniwlew/following{/other_user}","gists_url":"https://api.github.com/users/beriniwlew/gists{/gist_id}","starred_url":"https://api.github.com/users/beriniwlew/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beriniwlew/subscriptions","organizations_url":"https://api.github.com/users/beriniwlew/orgs","repos_url":"https://api.github.com/users/beriniwlew/repos","events_url":"https://api.github.com/users/beriniwlew/events{/privacy}","received_events_url":"https://api.github.com/users/beriniwlew/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-03-22T20:17:44Z","updated_at":"2018-03-23T18:16:16Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"I'm checking in to using Azure SQL Database, and everything seems to be working well so far.\r\n\r\nThere is an option, however, that I must enable when the db context is configured to retry the connections on failure:\r\n\r\n`builder.UseSqlServer(connectionString, opt => opt.EnableRetryOnFailure());`\r\n\r\nWhen a query is made, it throws the following exception:\r\n\r\n`InvalidOperationException: The configured execution strategy 'SqlServerRetryingExecutionStrategy' does not support user initiated transactions. Use the execution strategy returned by 'DbContext.Database.CreateExecutionStrategy()' to execute all the operations in the transaction as a retriable unit.`\r\n\r\nThere is more information about it here: \r\nhttps://docs.microsoft.com/en-us/ef/core/miscellaneous/connection-resiliency\r\n\r\nIs there anything I can do in order to make this work?"},"comment":{"url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/comments/375756254","html_url":"https://github.com/aspnetboilerplate/aspnetboilerplate/issues/3221#issuecomment-375756254","issue_url":"https://api.github.com/repos/aspnetboilerplate/aspnetboilerplate/issues/3221","id":375756254,"user":{"login":"beriniwlew","id":11966374,"avatar_url":"https://avatars1.githubusercontent.com/u/11966374?v=4","gravatar_id":"","url":"https://api.github.com/users/beriniwlew","html_url":"https://github.com/beriniwlew","followers_url":"https://api.github.com/users/beriniwlew/followers","following_url":"https://api.github.com/users/beriniwlew/following{/other_user}","gists_url":"https://api.github.com/users/beriniwlew/gists{/gist_id}","starred_url":"https://api.github.com/users/beriniwlew/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beriniwlew/subscriptions","organizations_url":"https://api.github.com/users/beriniwlew/orgs","repos_url":"https://api.github.com/users/beriniwlew/repos","events_url":"https://api.github.com/users/beriniwlew/events{/privacy}","received_events_url":"https://api.github.com/users/beriniwlew/received_events","type":"User","site_admin":false},"created_at":"2018-03-23T18:16:16Z","updated_at":"2018-03-23T18:16:16Z","author_association":"CONTRIBUTOR","body":"Shouldn't we be retrying db connection failures anyway, regardless of whether or not Azure is used?\r\n\r\nPerhaps it's good practice?"}}
{"actor":{"display_login":"beriniwlew"}}