Connecting to a Data Source in ADO.NET

In ADO.NET you use a Connection object to connect to a specific data source by supplying necessary authentication information in a connection string. The Connection object you use depends on the type of data source.

Each .NET Framework data provider included with the .NET Framework has a DbConnection object: the .NET Framework Data Provider for OLE DB includes an OleDbConnection object, the .NET Framework Data Provider for SQL Server includes a SqlConnection object, the .NET Framework Data Provider for ODBC includes an OdbcConnection object, and the .NET Framework Data Provider for Oracle includes an OracleConnection object.

In This Section

Establishing the Connection
Describes how to use a Connection object to establish a connection to a data source.

Connection Events
Describes how to use an InfoMessage event to retrieve informational messages from a data source.

See Also

Connection Strings
Connection Pooling
Commands and Parameters
DataAdapters and DataReaders
Transactions and Concurrency
ADO.NET Managed Providers and DataSet Developer Center