{"action":"created","issue":{"url":"https://api.github.com/repos/jonwagner/Insight.Database/issues/181","labels_url":"https://api.github.com/repos/jonwagner/Insight.Database/issues/181/labels{/name}","comments_url":"https://api.github.com/repos/jonwagner/Insight.Database/issues/181/comments","events_url":"https://api.github.com/repos/jonwagner/Insight.Database/issues/181/events","html_url":"https://github.com/jonwagner/Insight.Database/issues/181","id":53353417,"number":181,"title":"issue with connection + transaction","user":{"login":"hgjura","id":9681487,"avatar_url":"https://avatars.githubusercontent.com/u/9681487?v=3","gravatar_id":"","url":"https://api.github.com/users/hgjura","html_url":"https://github.com/hgjura","followers_url":"https://api.github.com/users/hgjura/followers","following_url":"https://api.github.com/users/hgjura/following{/other_user}","gists_url":"https://api.github.com/users/hgjura/gists{/gist_id}","starred_url":"https://api.github.com/users/hgjura/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hgjura/subscriptions","organizations_url":"https://api.github.com/users/hgjura/orgs","repos_url":"https://api.github.com/users/hgjura/repos","events_url":"https://api.github.com/users/hgjura/events{/privacy}","received_events_url":"https://api.github.com/users/hgjura/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-04T23:47:06Z","updated_at":"2015-01-05T19:35:55Z","closed_at":"2015-01-05T19:35:55Z","body":"Hello \r\n\r\nI am trying to open a conn + transaction in the following form:\r\nusing (var db = (new SqlConnection(ManualConnectionString))).OpenWithTransaction()) {...}\r\n\r\nbut I receive errors. It seems this extension is available only with ConnectionStringSetting.\r\n\r\nIf it exists, what would be the usage of OpenWithTransaction() with a SqlConnection object.\r\n\r\nThanks.  "},"comment":{"url":"https://api.github.com/repos/jonwagner/Insight.Database/issues/comments/68762907","html_url":"https://github.com/jonwagner/Insight.Database/issues/181#issuecomment-68762907","issue_url":"https://api.github.com/repos/jonwagner/Insight.Database/issues/181","id":68762907,"user":{"login":"jonwagner","id":1652596,"avatar_url":"https://avatars.githubusercontent.com/u/1652596?v=3","gravatar_id":"","url":"https://api.github.com/users/jonwagner","html_url":"https://github.com/jonwagner","followers_url":"https://api.github.com/users/jonwagner/followers","following_url":"https://api.github.com/users/jonwagner/following{/other_user}","gists_url":"https://api.github.com/users/jonwagner/gists{/gist_id}","starred_url":"https://api.github.com/users/jonwagner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jonwagner/subscriptions","organizations_url":"https://api.github.com/users/jonwagner/orgs","repos_url":"https://api.github.com/users/jonwagner/repos","events_url":"https://api.github.com/users/jonwagner/events{/privacy}","received_events_url":"https://api.github.com/users/jonwagner/received_events","type":"User","site_admin":false},"created_at":"2015-01-05T19:35:55Z","updated_at":"2015-01-05T19:35:55Z","body":"Kevin is right. There's a version of OpenWithTransaction that works with an IDbConnection. You just need the using statement. Let me know if that doesn't work for you."}}