{"action":"created","issue":{"url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/5653","labels_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/5653/labels{/name}","comments_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/5653/comments","events_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/5653/events","html_url":"https://github.com/OrchardCMS/Orchard/issues/5653","id":101638961,"number":5653,"title":"Retry logic and transient fault handling for Azure SQL","user":{"login":"dcinzona","id":52411,"avatar_url":"https://avatars.githubusercontent.com/u/52411?v=3","gravatar_id":"","url":"https://api.github.com/users/dcinzona","html_url":"https://github.com/dcinzona","followers_url":"https://api.github.com/users/dcinzona/followers","following_url":"https://api.github.com/users/dcinzona/following{/other_user}","gists_url":"https://api.github.com/users/dcinzona/gists{/gist_id}","starred_url":"https://api.github.com/users/dcinzona/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dcinzona/subscriptions","organizations_url":"https://api.github.com/users/dcinzona/orgs","repos_url":"https://api.github.com/users/dcinzona/repos","events_url":"https://api.github.com/users/dcinzona/events{/privacy}","received_events_url":"https://api.github.com/users/dcinzona/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-18T11:53:24Z","updated_at":"2015-08-18T18:49:02Z","closed_at":null,"body":"We are using Orchard 1.9.1 running on Azure Web Apps with an Azure SQL DB backend in an elastic pool.  At least 4 or 5 times a week, we drop connectivity to the Azure SQL database, causing catastrophic failure of the web application.  My guess is that the Orchard NHibernate data provider for Azure SQL is using an old model and is has not been updated.\r\n\r\nHere is the line that stands out to me: https://github.com/OrchardCMS/Orchard/blob/dev/src/Orchard/Data/Providers/SqlServerDataServicesProvider.cs#L30\r\n\r\nI also looked through the lib directory and was unable to find NHibernate.SqlAzure: https://github.com/MRCollective/NHibernate.SqlAzure\r\n\r\nDo we need to include the NHibernate.SqlAzure library in the lib folder (considering that there is an automated deployment option for Azure now) and does the data services provider need to be modified to support the new library?"},"comment":{"url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/comments/132316019","html_url":"https://github.com/OrchardCMS/Orchard/issues/5653#issuecomment-132316019","issue_url":"https://api.github.com/repos/OrchardCMS/Orchard/issues/5653","id":132316019,"user":{"login":"dcinzona","id":52411,"avatar_url":"https://avatars.githubusercontent.com/u/52411?v=3","gravatar_id":"","url":"https://api.github.com/users/dcinzona","html_url":"https://github.com/dcinzona","followers_url":"https://api.github.com/users/dcinzona/followers","following_url":"https://api.github.com/users/dcinzona/following{/other_user}","gists_url":"https://api.github.com/users/dcinzona/gists{/gist_id}","starred_url":"https://api.github.com/users/dcinzona/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dcinzona/subscriptions","organizations_url":"https://api.github.com/users/dcinzona/orgs","repos_url":"https://api.github.com/users/dcinzona/repos","events_url":"https://api.github.com/users/dcinzona/events{/privacy}","received_events_url":"https://api.github.com/users/dcinzona/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T18:49:02Z","updated_at":"2015-08-18T18:49:02Z","body":"Are you referring to the Connection Timeout property?  Because we have had that in our connection string for about a year - it doesn't not maintain the connection.  If there's a different property that we should include (I looked at the link you sent briefly but didn't see anything that stood out), can you post it here?\r\n\r\n"}}