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