Visual Studio 2008 sql query syntax; drop the brackets

Is there a way to configure VS2008 so that it does NOT create SQL query strings with square brackets in my ASP .Net projects? I'm using a开发者_高级运维 MySQL DB which doesn't like the brackets. Thanks.

There's an option in the latest version of the MySQL connector which might help:

Sql Server Mode

Allow SQL Server syntax. When set to true enables Connector/NET to support square brackets around symbols instead of backticks. This enables Visual Studio wizards that bracket symbols with [] to work with Connector/NET. This option incurs a performance hit, so should only be used if necessary. This option was added in version 6.3.1.