PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Are there any DbCommandBuilder implementation examples?

Reply

Are there any DbCommandBuilder implementation examples?

 
Thread Tools Rate Thread
Old 08-02-2006, 09:09 PM   #1
=?Utf-8?B?SmltIEhhcnR6ZWxs?=
Guest
 
Posts: n/a
Default Are there any DbCommandBuilder implementation examples?


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

  Reply With Quote
Old 08-02-2006, 09:16 PM   #2
W.G. Ryan - MVP
Guest
 
Posts: n/a
Default Re: Are there any DbCommandBuilder implementation examples?

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.
"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
>



  Reply With Quote
Old 09-02-2006, 07:09 AM   #3
Cor Ligthert [MVP]
Guest
 
Posts: n/a
Default Re: Are there any DbCommandBuilder implementation examples?

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...12-d7c12bbb3726

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

I hope this helps,

Cor


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off