Code: Select all
MySqlConnection conn = new MySqlConnection("server=server1;User id=userid; Password=password;Database=[b]DASHBOARD_PROD[/b]"); MySqlSyncDescriptionBuilder.GetDescriptionForTable("NB_ADDITIONAL_NOTES" conn);
SHOW KEYS FROM NB_ADDITIONAL_NOTES FROM dashboard_prod WHERE Column_name LIKE '%'
SHOW COLUMNS FROM NB_ADDITIONAL_NOTES FROM dashboard_prod LIKE '%'
As you can see, the database name was converted to lowercase in the SHOW command and since the database names are case sensitive, it does not find the table. This prevents me from provisioning scopes in my database.
Is there any way to prevent that method from converting the database name from the connectstring to lowercase?