Export (0) Print
Expand All

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.

See Also

Show:
© 2014 Microsoft