Bug #53157 .net connector putting square bracket [ ] in visual studio 2010

Description:
yes yes, I know that visual studio is very closely linked to sql server, thats why it is putting the square bracket ([ ]) around the table names.  However this is quite annoying having to go back to the codes and delete the square brackets.  I have noted this bug from visual studio 2008 and now it continues in vs2010.  I am sure that the geniuses in mysql can do something to remove this annoyance and make us coders more productive????

How to repeat:
in "configure data source", use the mysql connector to select database and tables.  The square bracket is added automatically to the sql statement

Suggested fix:
make a connector for visual basic that removes the [ ] from codes or even better make "configure data source" that is only for mysql.

Hi Kris and thanks for your report.

Unfortunately I have no access to VS2010 so assigning Wlad to check.

This is not a bug.  As you have said, the connector is not adding the [].  Please check out the new connection string option "sql server mode=yes".  This mode can be added when using a VS wizard.  It will attempt to replace [] with `` to make it mysql compat.  I would suggest removing that option for production code as it will cause a slight slowdown in sql execution.

yes, we can force VS 2010 to replace [] with `` but you are right it behaves slower.  Maybe better if you can create mySQLDatasource instead