{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1665","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1665/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1665/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1665/events","html_url":"https://github.com/aspnet/EntityFramework/issues/1665","id":58377664,"number":1665,"title":"MARS requirement gives issues for DB's that don't support this","user":{"login":"bartdevriendt","id":781706,"avatar_url":"https://avatars.githubusercontent.com/u/781706?v=3","gravatar_id":"","url":"https://api.github.com/users/bartdevriendt","html_url":"https://github.com/bartdevriendt","followers_url":"https://api.github.com/users/bartdevriendt/followers","following_url":"https://api.github.com/users/bartdevriendt/following{/other_user}","gists_url":"https://api.github.com/users/bartdevriendt/gists{/gist_id}","starred_url":"https://api.github.com/users/bartdevriendt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bartdevriendt/subscriptions","organizations_url":"https://api.github.com/users/bartdevriendt/orgs","repos_url":"https://api.github.com/users/bartdevriendt/repos","events_url":"https://api.github.com/users/bartdevriendt/events{/privacy}","received_events_url":"https://api.github.com/users/bartdevriendt/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/pri0","name":"pri0","color":"e11d21"}],"state":"open","locked":false,"assignee":{"login":"anpete","id":1210944,"avatar_url":"https://avatars.githubusercontent.com/u/1210944?v=3","gravatar_id":"","url":"https://api.github.com/users/anpete","html_url":"https://github.com/anpete","followers_url":"https://api.github.com/users/anpete/followers","following_url":"https://api.github.com/users/anpete/following{/other_user}","gists_url":"https://api.github.com/users/anpete/gists{/gist_id}","starred_url":"https://api.github.com/users/anpete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anpete/subscriptions","organizations_url":"https://api.github.com/users/anpete/orgs","repos_url":"https://api.github.com/users/anpete/repos","events_url":"https://api.github.com/users/anpete/events{/privacy}","received_events_url":"https://api.github.com/users/anpete/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/7","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/7/labels","id":666128,"number":7,"title":"7.0.0","description":"","creator":{"login":"rowanmiller","id":4741851,"avatar_url":"https://avatars.githubusercontent.com/u/4741851?v=3","gravatar_id":"","url":"https://api.github.com/users/rowanmiller","html_url":"https://github.com/rowanmiller","followers_url":"https://api.github.com/users/rowanmiller/followers","following_url":"https://api.github.com/users/rowanmiller/following{/other_user}","gists_url":"https://api.github.com/users/rowanmiller/gists{/gist_id}","starred_url":"https://api.github.com/users/rowanmiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rowanmiller/subscriptions","organizations_url":"https://api.github.com/users/rowanmiller/orgs","repos_url":"https://api.github.com/users/rowanmiller/repos","events_url":"https://api.github.com/users/rowanmiller/events{/privacy}","received_events_url":"https://api.github.com/users/rowanmiller/received_events","type":"User","site_admin":false},"open_issues":168,"closed_issues":155,"state":"open","created_at":"2014-05-21T19:25:32Z","updated_at":"2015-02-20T19:59:25Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-02-20T16:42:31Z","updated_at":"2015-02-20T20:05:43Z","closed_at":null,"body":"Working on my provider for MySQL i'm running into troubles with the MARS requirement.  As MySql doesn't support this all the outer queries fail with the already open DataReader exception.   I managed to workaround this by catching the exception in my DB Command wrapper object and opening a new connection to the database and creating a reader on this new connection.  Luckily the MySql connector has connection pooling by default so not too many connections are opened, but still all the \"cloned\" connections are untracked and undisposed.\r\n\r\nIs there a possibility this MARS requirement is reconsidered, or some kind of option is introduced to turn this of ?"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/75309617","html_url":"https://github.com/aspnet/EntityFramework/issues/1665#issuecomment-75309617","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/1665","id":75309617,"user":{"login":"anpete","id":1210944,"avatar_url":"https://avatars.githubusercontent.com/u/1210944?v=3","gravatar_id":"","url":"https://api.github.com/users/anpete","html_url":"https://github.com/anpete","followers_url":"https://api.github.com/users/anpete/followers","following_url":"https://api.github.com/users/anpete/following{/other_user}","gists_url":"https://api.github.com/users/anpete/gists{/gist_id}","starred_url":"https://api.github.com/users/anpete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anpete/subscriptions","organizations_url":"https://api.github.com/users/anpete/orgs","repos_url":"https://api.github.com/users/anpete/repos","events_url":"https://api.github.com/users/anpete/events{/privacy}","received_events_url":"https://api.github.com/users/anpete/received_events","type":"User","site_admin":false},"created_at":"2015-02-20T20:05:43Z","updated_at":"2015-02-20T20:05:43Z","body":"@bartdevriendt This is really just a limitation of our _default_ query compiler in our core provider framework - one we will probably address at some point. A couple of things to consider:\r\n\r\n1) When compiling a query, you have complete control over the expression tree produced and you can opt out of our default behavior by overriding the appropriate VisitX method in your query model visitor.\r\n2) Have you considered completely buffering the results from the outer reader so that you can close that reader?\r\n\r\nCheers,\r\nAndrew.\r\n\r\n\r\n"}}