Are there any DbCommandBuilder implementation examples?

[Guest]

Are there any examples of how to correctly implement a class inheriting from
DbCommandBuilder? I have not been able to find any examples showing best
practices for doing this.

I would like to implement a custom command builder class similar to
SQLCommandBuilder.

Thanks in advance,

Jim

 

[W.G. Ryan - MVP]

Hit MSN Search for the data Access Application Block. There's some
interesting uses with the commandbuilder that involve deriving the
parameters that will probably be of help for such a project.
CommandBuilders have a lot of baggage though and you'd probably be a lot
better off building your DALC with a better implementation.

 

[Cor Ligthert [MVP]]

Jim,

I tried it, however AFAIK is the commandbuilder building those commands
which are needed at that moment to use(the dataadapter references to it).
It is not a kind of generic commandbuilder.

Here a sample how to build those commands by hand.

http://www.vb-tips.com/default.aspx?ID=3405596d-4556-4aa8-be12-d7c12bbb3726

There is as well a sample with OLEDB on our site, what is quiet different in
this.

I hope this helps,

Cor