Edit

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 ADO.NET data provider has a DbConnection object: the .NET Framework Data Provider for OLE DB includes an OleDbConnection object, Microsoft.Data.SqlClient 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