Connecting to a data source in ADO.NET

Applies to: .NET Framework .NET .NET Standard

Download ADO.NET

In the Microsoft SqlClient data provider, 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.

The Microsoft SqlClient Data Provider for SQL Server includes a SqlConnection type that is derived from a DbConnection class.

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

• Connection strings
• Connection pooling
• Commands and parameters
• DataAdapters and DataReaders
• Transactions and concurrency
• Microsoft ADO.NET for SQL Server