{"action":"created","issue":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/213","repository_url":"https://api.github.com/repos/fsprojects/SQLProvider","labels_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/213/labels{/name}","comments_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/213/comments","events_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/213/events","html_url":"https://github.com/fsprojects/SQLProvider/issues/213","id":127172087,"number":213,"title":"mysql field, constructor or member not defined","user":{"login":"AngelMunoz","id":8684875,"avatar_url":"https://avatars.githubusercontent.com/u/8684875?v=3","gravatar_id":"","url":"https://api.github.com/users/AngelMunoz","html_url":"https://github.com/AngelMunoz","followers_url":"https://api.github.com/users/AngelMunoz/followers","following_url":"https://api.github.com/users/AngelMunoz/following{/other_user}","gists_url":"https://api.github.com/users/AngelMunoz/gists{/gist_id}","starred_url":"https://api.github.com/users/AngelMunoz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AngelMunoz/subscriptions","organizations_url":"https://api.github.com/users/AngelMunoz/orgs","repos_url":"https://api.github.com/users/AngelMunoz/repos","events_url":"https://api.github.com/users/AngelMunoz/events{/privacy}","received_events_url":"https://api.github.com/users/AngelMunoz/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":16,"created_at":"2016-01-18T07:53:48Z","updated_at":"2016-06-01T11:09:04Z","closed_at":"2016-06-01T11:09:04Z","body":"Hello, I'm learning F# and when I came with the database part I figured out that I wanted to use mysql instead sql server, the thing is that It's been quite hard to get this working and I find a lack of mysql examples\r\nI've been looking at issues with mysql but couldn't fine one that suits me, so far I got this\r\n```fs\r\nopen System.Linq\r\nopen FSharp.Data.Sql\r\nmodule Db2 =\r\n    type mysql = SqlDataProvider<\r\n                   ConnectionString  = \"server=localhost;user=Tuna;password=Admin123;persistsecurityinfo=True;database=personsdb;allowuservariables=True\",\r\n                   DatabaseVendor = Common.DatabaseProviderTypes.MYSQL,\r\n                   UseOptionTypes = true,\r\n                   ResolutionPath = @\"C:\\Program Files (x86)\\MySQL\\Connector.NET 6.9\\Assemblies\\v4.5\"\r\n               >\r\n    let ctx = mysql.GetDataContext()\r\n    let GetAllUsers = \r\n        query {\r\n            for user in ctx.personsdb.persons do\r\n        }\r\n```\r\nbut after ctx in ``for user in ctx.Personsdb.persons do`` the message\r\n> The field, constructor or member 'personsdb' is not defined\r\n\r\nand well I can't get past there could anyone point me in the right direction please?\r\nby the way I'm using the latest version from nuget"},"comment":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/comments/222961847","html_url":"https://github.com/fsprojects/SQLProvider/issues/213#issuecomment-222961847","issue_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/213","id":222961847,"user":{"login":"Thorium","id":229355,"avatar_url":"https://avatars.githubusercontent.com/u/229355?v=3","gravatar_id":"","url":"https://api.github.com/users/Thorium","html_url":"https://github.com/Thorium","followers_url":"https://api.github.com/users/Thorium/followers","following_url":"https://api.github.com/users/Thorium/following{/other_user}","gists_url":"https://api.github.com/users/Thorium/gists{/gist_id}","starred_url":"https://api.github.com/users/Thorium/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Thorium/subscriptions","organizations_url":"https://api.github.com/users/Thorium/orgs","repos_url":"https://api.github.com/users/Thorium/repos","events_url":"https://api.github.com/users/Thorium/events{/privacy}","received_events_url":"https://api.github.com/users/Thorium/received_events","type":"User","site_admin":false},"created_at":"2016-06-01T11:09:04Z","updated_at":"2016-06-01T11:09:04Z","body":"Now there are working examples in the documentation and the error reporting is better than earlier.\r\nE.g. in this case `mysql.PossibleError` property having tooltip to suggest what you should improve.\r\n\r\nSo this should be fine.\r\n"}}
{"actor":{"display_login":"Thorium"}}