All Connection objects implement the IDbConnection interface from the System.Data namespace and are thus quite similar. Provider-specific connection objects sometimes differ by adding new informational properties and slightly different methods for supporting transactions and connection pooling.
Some Connection classes for ADO.NET providers are shown in Table 18-1.
Class |
Data source |
---|---|
System.Data.SqlClient.SqlConnection |
SQL Server |
System.Data.OleDb.OleDbConnection |
An OLE DB provider |
System.Data.Odbc.OdbcConnection |
An ODBC driver |
System.Data.OleDb.OracleConnection |
Oracle |
|