System.Data.Odbc Namespace

The System.Data.Odbc namespace is the .NET Framework Data Provider for ODBC.

Remarks

The .NET Framework Data Provider for ODBC describes a collection of classes used to access an ODBC data source in the managed space. Using the OdbcDataAdapter class, you can fill a memory-resident DataSet that you can use to query and update the data source.

For more information about how to use this namespace, see the OdbcDataReader, OdbcCommand, and OdbcConnection classes.

Classes

TypeReason
OdbcCommand

Represents an SQL statement or stored procedure to execute against a data source. This class cannot be inherited.

OdbcCommandBuilder

Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated data source. This class cannot be inherited.

OdbcConnection

Represents an open connection to a data source.

OdbcConnectionStringBuilder

Provides a simple way to create and manage the contents of connection strings used by the OdbcConnection class.

OdbcDataAdapter

Represents a set of data commands and a connection to a data source that are used to fill the DataSet and update the data source. This class cannot be inherited.

OdbcDataReader

Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.

OdbcError

Collects information relevant to a warning or error returned by the data source.

OdbcErrorCollection

Collects all errors generated by the OdbcDataAdapter. This class cannot be inherited.

OdbcException

The exception that is generated when a warning or error is returned by an ODBC data source. This class cannot be inherited.

OdbcFactory

Represents a set of methods for creating instances of the ODBC provider's implementation of the data source classes.

OdbcInfoMessageEventArgs

Provides data for the OdbcConnection.InfoMessage event.

OdbcInfoMessageEventHandler

Represents the method that will handle the OdbcConnection.InfoMessage event of an OdbcConnection.

OdbcMetaDataCollectionNames

Provides a list of constants for use with the GetSchema method to retrieve metadata collections.

OdbcMetaDataColumnNames

Provides static values that are used for the column names in the OdbcMetaDataCollectionNames objects contained in the DataTable. The DataTable is created by the GetSchema method.

OdbcParameter

Represents a parameter to an OdbcCommand and optionally, its mapping to a DataColumn. This class cannot be inherited.

OdbcParameterCollection

Represents a collection of parameters relevant to an OdbcCommand and their respective mappings to columns in a DataSet. This class cannot be inherited.

OdbcPermission

Enables the .NET Framework Data Provider for ODBC to help make sure that a user has a security level sufficient to access an ODBC data source. This class cannot be inherited.

OdbcPermissionAttribute

Associates a security action with a custom security attribute.

OdbcRowUpdatedEventArgs

Provides data for the OdbcDataAdapter.RowUpdated event.

OdbcRowUpdatedEventHandler

Represents the method that will handle the OdbcDataAdapter.RowUpdated event of an OdbcDataAdapter.

OdbcRowUpdatingEventArgs

Provides data for the OdbcDataAdapter.RowUpdating event.

OdbcRowUpdatingEventHandler

Represents the method that will handle the OdbcDataAdapter.RowUpdating event of an OdbcDataAdapter.

OdbcTransaction

Represents an SQL transaction to be made at a data source. This class cannot be inherited.

OdbcType

Specifies the data type of a field, property, for use in an OdbcParameter.