for RuBoard



Is it possible to use the Connection object in ADO.NET to send queries to the database as you could in ADO?


Nope. This functionality has been removed, by design. To query the database, you must create a Command object, which is covered in depth in the next hour .


My data source has a managed provider, an OLE DB provider, and ODBC drivers. Which one should I use?


Typically, the best option in terms of both speed and reliability is to use the managed provider. Your next best bet is to use the OLE DB provider. If everything else fails, use the ODBC .NET provider as you saw in this hour.

for RuBoard

Sams Teach Yourself ADO. NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237 © 2008-2017.
If you may any questions please contact us: