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.