{"action":"created","issue":{"url":"https://api.github.com/repos/tonyredondo/TWCore2/issues/1","repository_url":"https://api.github.com/repos/tonyredondo/TWCore2","labels_url":"https://api.github.com/repos/tonyredondo/TWCore2/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/tonyredondo/TWCore2/issues/1/comments","events_url":"https://api.github.com/repos/tonyredondo/TWCore2/issues/1/events","html_url":"https://github.com/tonyredondo/TWCore2/issues/1","id":292163970,"node_id":"MDU6SXNzdWUyOTIxNjM5NzA=","number":1,"title":"Use MySqlConnector for async I/O","user":{"login":"bgrainger","id":188129,"node_id":"MDQ6VXNlcjE4ODEyOQ==","avatar_url":"https://avatars2.githubusercontent.com/u/188129?v=4","gravatar_id":"","url":"https://api.github.com/users/bgrainger","html_url":"https://github.com/bgrainger","followers_url":"https://api.github.com/users/bgrainger/followers","following_url":"https://api.github.com/users/bgrainger/following{/other_user}","gists_url":"https://api.github.com/users/bgrainger/gists{/gist_id}","starred_url":"https://api.github.com/users/bgrainger/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bgrainger/subscriptions","organizations_url":"https://api.github.com/users/bgrainger/orgs","repos_url":"https://api.github.com/users/bgrainger/repos","events_url":"https://api.github.com/users/bgrainger/events{/privacy}","received_events_url":"https://api.github.com/users/bgrainger/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-01-28T00:05:05Z","updated_at":"2018-09-27T16:15:51Z","closed_at":"2018-09-27T16:15:51Z","author_association":"NONE","body":"The DataAccessBase code [uses `ExecuteReaderAsync`](https://github.com/tonyredondo/TWCore2/blob/adbcd77cb15b81d8f63a3ecebea54025d2d57411/src/TWCore.Data/DataAccessBase.cs#L1488). It's a long-standing bug in MySql.Data ([bug 70111](https://bugs.mysql.com/bug.php?id=70111)) that the async I/O methods are not implemented; thus all these methods will fall back to running synchronously. (See also [here](https://stackoverflow.com/a/42305108/) and [here](https://stackoverflow.com/questions/30551459/mysql-c-sharp-async-methods-doesnt-work) on Stack Overflow.)\r\n\r\nTo fix this, you could switch to https://github.com/mysql-net/MySqlConnector, an OSS replacement for MySql.Data that supports true asynchronous I/O; it also has full .NET Standard support.\r\n\r\nIf you're interested in this, I'd be happy to open a PR."},"comment":{"url":"https://api.github.com/repos/tonyredondo/TWCore2/issues/comments/425153510","html_url":"https://github.com/tonyredondo/TWCore2/issues/1#issuecomment-425153510","issue_url":"https://api.github.com/repos/tonyredondo/TWCore2/issues/1","id":425153510,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNTE1MzUxMA==","user":{"login":"tonyredondo","id":69803,"node_id":"MDQ6VXNlcjY5ODAz","avatar_url":"https://avatars0.githubusercontent.com/u/69803?v=4","gravatar_id":"","url":"https://api.github.com/users/tonyredondo","html_url":"https://github.com/tonyredondo","followers_url":"https://api.github.com/users/tonyredondo/followers","following_url":"https://api.github.com/users/tonyredondo/following{/other_user}","gists_url":"https://api.github.com/users/tonyredondo/gists{/gist_id}","starred_url":"https://api.github.com/users/tonyredondo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tonyredondo/subscriptions","organizations_url":"https://api.github.com/users/tonyredondo/orgs","repos_url":"https://api.github.com/users/tonyredondo/repos","events_url":"https://api.github.com/users/tonyredondo/events{/privacy}","received_events_url":"https://api.github.com/users/tonyredondo/received_events","type":"User","site_admin":false},"created_at":"2018-09-27T16:15:51Z","updated_at":"2018-09-27T16:15:51Z","author_association":"OWNER","body":"Using MySqlConnector on v2.1.177"}}
{"actor":{"display_login":"tonyredondo"}}