A.3 The ODBC .NET Provider

The ODBC .NET provider is a set of managed classes (see Table A-6) that provides access to a database through any ODBC driver installed on your computer. To find the ODBC .NET driver, navigate to http://msdn.microsoft.com and search for ODBC .NET. If you have Version 1.1 of the .NET Framework SDK, ODBC .NET is included.

Table A-6. ODBC .NET provider classes

Interface

Implementing class

IDbConnection
OdbcConnection
IDbCommand
OdbcCommand

IDataParameter, IDbDataParameter

OdbcParameter

IDataReader, IDataRecord

OdbcDataReader

IDataAdapter, IDbDataAdapter

OdbcDataAdapter
IDbTransaction
OdbcTransaction

In .NET 1.1, these types are defined in the SystemData.dll assembly and contained in the System.Data.Odbc namespace. With earlier versions of .NET, you need to install the Microsoft.Data.Odbc.dll assembly (available form the MSDN site as a separate download), reference it, and import the Microsoft.Data.Odbc namespace.



    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference