18.1 CommentsTroubleshooting

18.1 Comments/Troubleshooting

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.

Table 18-1. Provider-specific Connection classes

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



ADO. NET in a Nutshell
ADO.NET in a Nutshell
ISBN: 0596003617
EAN: 2147483647
Year: 2005
Pages: 415

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net