{"action":"created","issue":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/152","labels_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/152/labels{/name}","comments_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/152/comments","events_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/152/events","html_url":"https://github.com/fsprojects/SQLProvider/issues/152","id":98945778,"number":152,"title":"Changing database schema does not have effect in MySQL provider","user":{"login":"jasonweiyi","id":234931,"avatar_url":"https://avatars.githubusercontent.com/u/234931?v=3","gravatar_id":"","url":"https://api.github.com/users/jasonweiyi","html_url":"https://github.com/jasonweiyi","followers_url":"https://api.github.com/users/jasonweiyi/followers","following_url":"https://api.github.com/users/jasonweiyi/following{/other_user}","gists_url":"https://api.github.com/users/jasonweiyi/gists{/gist_id}","starred_url":"https://api.github.com/users/jasonweiyi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jasonweiyi/subscriptions","organizations_url":"https://api.github.com/users/jasonweiyi/orgs","repos_url":"https://api.github.com/users/jasonweiyi/repos","events_url":"https://api.github.com/users/jasonweiyi/events{/privacy}","received_events_url":"https://api.github.com/users/jasonweiyi/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-08-04T11:22:56Z","updated_at":"2015-08-04T12:03:54Z","closed_at":null,"body":"I first created a MySQL type provider by specifying Database=db1, and successfully got the types created. But when I change to Database=db2, the created types are still for db1. Meaning that when I try to do Intellisense, the suggested types does not contain db2, and when I try to write a query for db2, the query expression does not type check. I tried to restart Visual Studio, the problem does not go away.\r\n\r\nThe following is my code:\r\n\r\n#r \"../../packages/MySql.Data.6.9.7/lib/net45/MySql.Data.dll\" \r\n#r \"../../packages/SQLProvider.0.0.9-alpha/lib/net40/FSharp.Data.SqlProvider.dll\"\r\n\r\nopen System\r\nopen System.Linq\r\nopen FSharp.Data.Sql\r\nopen MySql.Data\r\n\r\n[<Literal>]\r\nlet ResolutionPath = @\"SOME_FOLDER\\packages\\MySql.Data.6.9.7\\lib\\net45\"\r\n\r\ntype sql = SqlDataProvider<\"Server=SERVER_NAME;Database=db2;Uid=USER;Pwd=PASSWORD\", Common.DatabaseProviderTypes.MYSQL,ResolutionPath=ResolutionPath>\r\nlet ctxt = sql.GetDataContext()\r\n\r\nI used Database=db1 first, it worked. But when I change to Database=db2, the generated types does not contain the ones for db2. I do have db2 in my database and I can access it through MySQL workbench under the connection string.\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/comments/127578188","html_url":"https://github.com/fsprojects/SQLProvider/issues/152#issuecomment-127578188","issue_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/152","id":127578188,"user":{"login":"pezipink","id":2384821,"avatar_url":"https://avatars.githubusercontent.com/u/2384821?v=3","gravatar_id":"","url":"https://api.github.com/users/pezipink","html_url":"https://github.com/pezipink","followers_url":"https://api.github.com/users/pezipink/followers","following_url":"https://api.github.com/users/pezipink/following{/other_user}","gists_url":"https://api.github.com/users/pezipink/gists{/gist_id}","starred_url":"https://api.github.com/users/pezipink/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pezipink/subscriptions","organizations_url":"https://api.github.com/users/pezipink/orgs","repos_url":"https://api.github.com/users/pezipink/repos","events_url":"https://api.github.com/users/pezipink/events{/privacy}","received_events_url":"https://api.github.com/users/pezipink/received_events","type":"User","site_admin":false},"created_at":"2015-08-04T12:03:54Z","updated_at":"2015-08-04T12:03:54Z","body":"ahh yes you are correct, it does seem to use Owner.  @jasonweiyi if you can try that ...."}}