Here's an overview of this chapter's topics:
Connection objects support the connections to data sources in ADO.NET. You need a connection object, such as an OleDbConnection, SqlConnection, OdbcConnection or OracleConnection object, to connect to a database.
When you have a connection object, you can use that object's Open method to open the connection, and assign the object to the Connection property of a command object. You store the SQL you want to execute in command objects, and you can create command objects that will select data from the data source, insert new records, delete records, and update the database. Each command object has a connection object associated with it.
You use command objects with data adapter objects. Data adapters ...