开发者

Visual Studio 2008 sql query syntax; drop the brackets

开发者 https://www.devze.com 2023-01-20 19:49 出处:网络
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.Thank

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消