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
|
