Connecting to Data Sources
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 Connection 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 a Connection
Describes how to use the Connection object to establish a connection to a data source.
- Working with Connection Events
Describes how to use the InfoMessage event to retrieve informational messages from a data source.
- Understanding Connection Pooling
Describes how pooling connections can significantly enhance the performance and scalability of an ADO.NET application.
Reference
- DbConnection
Describes the DbConnection class and all of its members.
- OdbcConnection
Describes the OdbcConnection class and all of its members.
- OleDbConnection
Describes the OleDbConnection class and all of its members.
- OracleConnection
Describes the OracleConnection class and all of its members.
- SqlConnection
Describes the SqlConnection class and all of its members.