O'Reilly logo

Application Development Using Visual Basic® and .NET by Dana L. Wyatt, Peter Thorsteinson, Robert J. Oberg

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

Connected Data Access

Although much of the design of ADO.NET is geared to supporting disconnected database applications, there is also support for the connected model. Because connected applications are more familiar, we begin our detailed discussion of ADO.NET programming with the connected scenario.

Using a Connection

The connection class (OleDbConnection or SqlConnection) is used to manage the connection to the data source. It has properties for ConnectionString, ConnectionTimeout, and so forth. There are methods for Open, Close, transaction management, and so on.

A connection string is used to identify the information the object needs to connect to the database. You can specify the connection string when you construct the connection object, ...

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