SqlCommandBuilder bug

[Luke Painter]

When using SqlCommandBuilder, if one of the columns, of
the subject table referenced in the SELECT query, has a
column name that is an T-SQL reserved word, such as User,
the T-SQL command text for the adapter will be incorrect
and an SqlException will be thrown. This is because the
command builder fails to wrap the column name in square
brackets in the T-SQL statement. It would be a good idea
to either document this or fix it in a future release.

Regards,
Luke Painter

 

[Miha Markic [MVP C#]]

Hi Luke,

Or you might set QuotePrefix and QuoteSuffix.