{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/462","repository_url":"https://api.github.com/repos/npgsql/npgsql","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/462/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/462/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/462/events","html_url":"https://github.com/npgsql/npgsql/issues/462","id":55526063,"number":462,"title":"Implement MARS (Multiple Active Result Set)","user":{"login":"franciscojunior","id":829924,"avatar_url":"https://avatars1.githubusercontent.com/u/829924?v=3","gravatar_id":"","url":"https://api.github.com/users/franciscojunior","html_url":"https://github.com/franciscojunior","followers_url":"https://api.github.com/users/franciscojunior/followers","following_url":"https://api.github.com/users/franciscojunior/following{/other_user}","gists_url":"https://api.github.com/users/franciscojunior/gists{/gist_id}","starred_url":"https://api.github.com/users/franciscojunior/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/franciscojunior/subscriptions","organizations_url":"https://api.github.com/users/franciscojunior/orgs","repos_url":"https://api.github.com/users/franciscojunior/repos","events_url":"https://api.github.com/users/franciscojunior/events{/privacy}","received_events_url":"https://api.github.com/users/franciscojunior/received_events","type":"User","site_admin":false},"labels":[{"id":70004675,"url":"https://api.github.com/repos/npgsql/npgsql/labels/feature","name":"feature","color":"009800","default":false},{"id":70408799,"url":"https://api.github.com/repos/npgsql/npgsql/labels/research","name":"research","color":"bfe5bf","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":26,"created_at":"2015-01-26T19:30:49Z","updated_at":"2017-05-23T17:00:01Z","closed_at":null,"body":"Hi all!\n\nI'm opening this issue so we can discuss about how we could implement MARS in Npgsql.\n\n@bricelam gave us a heads up about the requirement of MARS by Entity Framework 7. https://github.com/npgsql/npgsql/issues/249#issuecomment-71501637\n\nI was reading the protocol documentation and there it says:\n\n```\nIf Execute terminates before completing the execution of a portal (due to reaching a nonzero result-row count), it will send a PortalSuspended message; the appearance of this message tells the frontend that another Execute should be issued against the same portal to complete the operation.\n```\n\nWould it be possible to have many portals open at the same time and send execute messages separately? \n\nSomething like this:\n\n```\nwhile (dr.Read())     <----- First portal suspended (read 10 first rows for example)\n{\n     blahblah()\n     while dr2.Read()   <---- Execute a second portal\n     {\n     }\n}\n```\n"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/303466376","html_url":"https://github.com/npgsql/npgsql/issues/462#issuecomment-303466376","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/462","id":303466376,"user":{"login":"marcosgerene","id":15945003,"avatar_url":"https://avatars0.githubusercontent.com/u/15945003?v=3","gravatar_id":"","url":"https://api.github.com/users/marcosgerene","html_url":"https://github.com/marcosgerene","followers_url":"https://api.github.com/users/marcosgerene/followers","following_url":"https://api.github.com/users/marcosgerene/following{/other_user}","gists_url":"https://api.github.com/users/marcosgerene/gists{/gist_id}","starred_url":"https://api.github.com/users/marcosgerene/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/marcosgerene/subscriptions","organizations_url":"https://api.github.com/users/marcosgerene/orgs","repos_url":"https://api.github.com/users/marcosgerene/repos","events_url":"https://api.github.com/users/marcosgerene/events{/privacy}","received_events_url":"https://api.github.com/users/marcosgerene/received_events","type":"User","site_admin":false},"created_at":"2017-05-23T17:00:01Z","updated_at":"2017-05-23T17:00:01Z","body":">It's also pretty bad practice to open a connection and then leave it, owned by your SalesDAL instance, >doing nothing until someone comes along and called ListComplete(). Thanks to connection pooling, >connections are extremely lightweight objects, and are better off being instantiated and opened only when >needed (i.e. inside your ListComplete() method).\r\n\r\nI don't use the connection in objects DAL, but I use a Connection class for it, it's a \"poor\" exemple"}}
{"actor":{"display_login":"marcosgerene"}}