CODEWITHSUNDEEP
asp.netmysqlvisual-studio-2008
john plourd
john plourd

Reputation: 155

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.

Upvotes: 1

Views: 798

Answers (1)

stuartd
stuartd

Reputation: 73283

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.

Upvotes: 2

Related Questions