O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

9.5. ADO Connections, Commands, and Transactions

Connected access and simple statement execution consists of using Connections and Commands. Local transactions are supported by using methods of the Connection class. As opposed to OLE DB, in ADO (classic) Connections and Commands are creatable classes. Let's go over the parallel of this usage in ADO.NET.

9.5.1. Connections and Connection Strings

You establish connections in ADO by instantiating a Connection and using a connection string to point to the data source. Because the ADO Connection is a generic object, the specific provider is specified as part of the connection string. In ADO.NET, you instantiate a strongly typed provider class, such as SqlConnection or OleDbConnection. Because the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required