MySQL Bugs: #53157: .net connector putting square bracket [ ] in visual studio 2010

Bug #53157	.net connector putting square bracket [ ] in visual studio 2010
Submitted:	26 Apr 2010 12:06	Modified:	28 Apr 2010 3:33
Reporter:	kris adidarma	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	6.3.1	OS:	Any
Assigned to:	Vladislav Vaintroub	CPU Architecture:	Any

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