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.
Describes the DbConnection class and all of its members.
Describes the OdbcConnection class and all of its members.
Describes the OleDbConnection class and all of its members.
Describes the OracleConnection class and all of its members.
Describes the SqlConnection class and all of its members.