Are there any DbCommandBuilder implementation examples?

microsoft.public.dotnet.framework.adonet

8 Feb 2006 9:09 PM

Jim Hartzell

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

8 Feb 2006 9:16 PM

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.
Show quote

"Jim Hartzell" <JimH@community.nospam> wrote in message
news:257352AC-C0CD-493D-A040-224435570C30@microsoft.com...
> 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
>

9 Feb 2006 7:09 AM

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