dbcommand verssus sqlcommand

microsoft.public.dotnet.framework.adonet

22 Jun 2006 8:25 PM

klumsy

I am using the enterprise library for ado.net 2.0, and we are working
out whether we should use the sqlcommand or dbcommand etc. If you are
using a dbcommand, is it being serviced through the OLEDB provider or
could it still be serviced through the SQL SERVER provider?

Karl

23 Jun 2006 4:42 AM

Cor Ligthert [MVP]

Klumsy,

dbcommand is the base class from the commands you mention, and therefore
used by those.

Have a look at factory in Net 2.0

http://msdn2.microsoft.com/en-us/library/system.data.common.dbproviderfactory.aspx

I hope this helps,

Cor

<klu***@xtra.co.nz> schreef in bericht
Show quote

news:1151007916.490342.292430@u72g2000cwu.googlegroups.com...
>I am using the enterprise library for ado.net 2.0, and we are working
> out whether we should use the sqlcommand or dbcommand etc. If you are
> using a dbcommand, is it being serviced through the OLEDB provider or
> could it still be serviced through the SQL SERVER provider?
>
> Karl
>