Hydrus Software Forums

Hello,

I am using the DST in an ASP.NET 1.1 application.  I create two instances of the CommandBuilder class and store them in application state.  One instance is configured to access a SQL Server database, and the other instance is configured to access a DB2 database.  I have a couple of questions and concerns:

1. Why are the QuotePrefix and QuoteSuffix properties of the CommandBuilder class static?  I would like my SQL Server CommandBuilder to use brackets to quote identifiers, and the DB2 CommandBuilder to use quotation marks, but I cannot configure my application to do so.
2. For some reason, the values in QuotePrefix and QuoteSuffix are not being saved with the CommandBuilders that I store in application.  After they are set, and without my application code touching them, they both get the value of empty string.  Please help!

Thanks,

John

Good questions.

1) The CommandBuilder was built as if there would be only one servicing your application. There are other design considerations to work through in order to change this presupposition.

2) Depends on your dbms type. Certain providers ignore this property (oracle for instance). With Db2 I am not sure. Sql's provider should maintain this setting, so if you are seeing this behavior with SqlServer, we would need to see your code to help you diagnose the issue.