.NET Framework Developer's Guide

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 a Connection object to establish a connection to a data source.

Working with Connection Events: Describes how to use an 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.

In This Section

Reference

See Also

Other Resources