{"action":"created","issue":{"url":"https://api.github.com/repos/tamasflamich/effort/issues/29","repository_url":"https://api.github.com/repos/tamasflamich/effort","labels_url":"https://api.github.com/repos/tamasflamich/effort/issues/29/labels{/name}","comments_url":"https://api.github.com/repos/tamasflamich/effort/issues/29/comments","events_url":"https://api.github.com/repos/tamasflamich/effort/issues/29/events","html_url":"https://github.com/tamasflamich/effort/issues/29","id":132112857,"number":29,"title":"Transaction aborted when using context.Database.BeginTransaction","user":{"login":"tompazourek","id":370699,"avatar_url":"https://avatars.githubusercontent.com/u/370699?v=3","gravatar_id":"","url":"https://api.github.com/users/tompazourek","html_url":"https://github.com/tompazourek","followers_url":"https://api.github.com/users/tompazourek/followers","following_url":"https://api.github.com/users/tompazourek/following{/other_user}","gists_url":"https://api.github.com/users/tompazourek/gists{/gist_id}","starred_url":"https://api.github.com/users/tompazourek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tompazourek/subscriptions","organizations_url":"https://api.github.com/users/tompazourek/orgs","repos_url":"https://api.github.com/users/tompazourek/repos","events_url":"https://api.github.com/users/tompazourek/events{/privacy}","received_events_url":"https://api.github.com/users/tompazourek/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":9,"created_at":"2016-02-08T11:12:11Z","updated_at":"2016-12-21T07:55:40Z","closed_at":null,"body":"When using this approach, the transaction commit throws:\n\n``` csharp\nusing (var transaction = context.Database.BeginTransaction()) {\n\n    // stuff\n\n    transaction.Commit(); // throws\n}\n```\n\nThe exception is:\n\n```\nSystem.Data.Entity.Infrastructure.CommitFailedException : An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server. See the inner exception and http://go.microsoft.com/fwlink/?LinkId=313468 for more information.\n  ----> System.Transactions.TransactionAbortedException : The transaction has aborted.\n  ----> System.TimeoutException : Transaction Timeout\n```\n\nHowever if I use `context.Database.Connection.BeginTransaction()` instead, it is working:\n\n``` csharp\nusing (var transaction = context.Database.Connection.BeginTransaction()) {\n\n    // stuff\n\n    transaction.Commit(); // doesn't throw\n}\n```\n\nEDIT: Probably something else happening.\n"},"comment":{"url":"https://api.github.com/repos/tamasflamich/effort/issues/comments/268459202","html_url":"https://github.com/tamasflamich/effort/issues/29#issuecomment-268459202","issue_url":"https://api.github.com/repos/tamasflamich/effort/issues/29","id":268459202,"user":{"login":"borismod","id":209971,"avatar_url":"https://avatars.githubusercontent.com/u/209971?v=3","gravatar_id":"","url":"https://api.github.com/users/borismod","html_url":"https://github.com/borismod","followers_url":"https://api.github.com/users/borismod/followers","following_url":"https://api.github.com/users/borismod/following{/other_user}","gists_url":"https://api.github.com/users/borismod/gists{/gist_id}","starred_url":"https://api.github.com/users/borismod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/borismod/subscriptions","organizations_url":"https://api.github.com/users/borismod/orgs","repos_url":"https://api.github.com/users/borismod/repos","events_url":"https://api.github.com/users/borismod/events{/privacy}","received_events_url":"https://api.github.com/users/borismod/received_events","type":"User","site_admin":false},"created_at":"2016-12-21T07:55:40Z","updated_at":"2016-12-21T07:55:40Z","body":"+1"}}
{"actor":{"display_login":"borismod"}}