From: Dieter B. <db...@sn...> - 2004-04-14 17:25:27
|
Well, this is probably a question for Carlos: Are you interested in source code for a design time CommandBuilder component? It was inspired by Delphi's TUpdateSql and is currently implemented as an SqlCommandBuilder but most of it could be of use for Firebird's provider. When connected to a SqlDataAdapter component it reads schema info from the db and saves it as XML in a string property. You can then choose which fields (changed or all) to include in UPDATE/INSERT and which fields (all, PkAndRowVer, ...) to use for optimistic locking. You can also specify whether to refresh records after UPDATE/INSERT. It comes with a basic testing environment, very few NUnit test, and even some comments ;-). But testing has been very limited. The component will be published in a german magazine (dotnetpro) and the publisher has agreed to make it available to open source projects. I have also offered it to the mono project. I have just learned that you (carlos) beat me by 2 weeks - 1.6 incorporates a CommandBuilderBehaviour property! Let me know if you are interested despite this. Thanks for providing firebird's .NET Data Provider and greetings from Berlin Dieter |