System.Data.Common Namespace

The System.Data.Common namespace contains classes shared by the.NET Framework data providers.

A .NET Framework data provider describes a collection of classes used to access a data source, such as a database, in the managed space. Supported providers include the .NET Framework Data Provider for ODBC, the .NET Framework Data Provider for OLEDB, the .NET Framework Data Provider for Oracle, and the .NET Framework Data Provider for SQL Server. The classes in System.Data.Common are intended to give developers a way to write ADO.NET code that will work against all .NET Framework data providers.

For conceptual information about how to use this namespace when programming with the.NET Framework, see Working with Factories.

Public classDataAdapterRepresents a set of SQL commands and a database connection that are used to fill the DataSet and update the data source.
Public classDataColumnMappingContains a generic column mapping for an object that inherits from DataAdapter. This class cannot be inherited.
Public classDataColumnMappingCollectionContains a collection of DataColumnMapping objects.
Public classDataTableMappingContains a description of a mapped relationship between a source table and a DataTable. This class is used by a DataAdapter when populating a DataSet.
Public classDataTableMappingCollectionA collection of DataTableMapping objects. This class cannot be inherited.
Public classDbCommandRepresents an SQL statement or stored procedure to execute against a data source. Provides a base class for database-specific classes that represent commands.
Public classDbCommandBuilderAutomatically generates single-table commands used to reconcile changes made to a DataSet with the associated database. This is an abstract class that can only be inherited.
Public classDbConnectionRepresents a connection to a database.
Public classDbConnectionStringBuilderProvides a base class for strongly typed connection string builders.
Public classDbDataAdapterAids implementation of the IDbDataAdapter interface. Inheritors of DbDataAdapter implement a set of functions to provide strong typing, but inherit most of the functionality needed to fully implement a DataAdapter.
Public classDBDataPermissionEnables a .NET Framework data provider to help ensure that a user has a security level adequate for accessing data.
Public classDBDataPermissionAttributeAssociates a security action with a custom security attribute.
Public classDbDataReaderReads a forward-only stream of rows from a data source.
Public classDbDataRecordImplements IDataRecord and ICustomTypeDescriptor, and provides data binding support for DbEnumerator.
Public classDbDataSourceEnumerator 
Public classDbEnumeratorExposes the GetEnumerator method, which supports a simple iteration over a collection by a .NET Framework data provider.
Public classDbExceptionThe base class for all exceptions thrown on behalf of the data source.
Public classDbMetaDataCollectionNamesProvides a list of constants for the well-known MetaDataCollections: DataSourceInformation, DataTypes, MetaDataCollections, ReservedWords, and Restrictions.
Public classDbMetaDataColumnNamesProvides static values that are used for the column names in the MetaDataCollection objects contained in the DataTable. The DataTable is created by the GetSchema method.
Public classDbParameterRepresents a parameter to a DbCommand and optionally, its mapping to a DataSet column.
Public classDbParameterCollectionThe base class for a collection of parameters relevant to a DbCommand.
Public classDbProviderConfigurationHandler 
Public classDbProviderFactoriesRepresents a set of static methods for creating one or more instances of DbProviderFactory classes.
Public classDbProviderFactoriesConfigurationHandler 
Public classDbProviderFactoryRepresents a set of methods for creating instances of a provider's implementation of the data source classes.
Public classDbProviderSpecificTypePropertyAttributeIdentifies which provider-specific property in the strongly typed parameter classes is to be used when setting a provider-specific type.
Public classDbTransactionThe base class for a transaction.
Public classRowUpdatedEventArgsProvides data for the RowUpdated event of a .NET Framework data provider.
Public classRowUpdatingEventArgsProvides the data for the RowUpdating event of a .NET Framework data provider.
Public classSchemaTableColumnDescribes the column metadata of the schema for a database table.
Public classSchemaTableOptionalColumnDescribes optional column metadata of the schema for a database table.

Public enumerationCatalogLocationIndicates the position of the catalog name in a qualified table name in a text command.
Public enumerationGroupByBehaviorSpecifies the relationship between the columns in a GROUP BY clause and the non-aggregated columns in the select-list of a SELECT statement.
Public enumerationIdentifierCaseSpecifies how identifiers are treated by the data source when searching the system catalog.
Public enumerationSupportedJoinOperatorsSpecifies what types of Transact-SQL join statements are supported by the data source.