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, ...

Get Application Development Using Visual Basic® and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.