In our current project we have a column in our database named 'key' (yea, i know - naughty naughty). Anyway, the dataset toolkit throws an exception when trying to fill this table. Is there anyway around this? Doing things the old-skool way with the old dataAdapter works fine. In order to use the datasettoolkit does one need to avoid using reserved words or is there a better way to handle this?
Thoughts?
Here's the SqlException when I do a multiAdapter.Fill():
System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'Key'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
...
etc.