Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content

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 Writing Provider Independent Code with ADO.NET.

  Class Description
Public class DataAdapter Represents a set of SQL commands and a database connection that are used to fill the DataSet and update the data source.
Public class DataColumnMapping Contains a generic column mapping for an object that inherits from DataAdapter. This class cannot be inherited.
Public class DataColumnMappingCollection Contains a collection of DataColumnMapping objects.
Public class DataRecordInfo Provides access to information about the structural type and column information for a DbDataRecord.
Public class DataTableMapping Contains 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 class DataTableMappingCollection A collection of DataTableMapping objects. This class cannot be inherited.
Public class DbCommand Represents an SQL statement or stored procedure to execute against a data source. Provides a base class for database-specific classes that represent commands. ExecuteNonQueryAsync
Public class DbCommandBuilder Automatically 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 class DbCommandDefinition Defines a cacheable command plan.
Public class DbConnection Represents a connection to a database.
Public class DbConnectionStringBuilder Provides a base class for strongly typed connection string builders.
Public class DbDataAdapter Aids 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 class DBDataPermission Enables a .NET Framework data provider to help ensure that a user has a security level adequate for accessing data.
Public class DBDataPermissionAttribute Associates a security action with a custom security attribute.
Public class DbDataReader Reads a forward-only stream of rows from a data source.
Public class DbDataRecord Implements IDataRecord and ICustomTypeDescriptor, and provides data binding support for DbEnumerator.
Public class DbDataSourceEnumerator Provides a mechanism for enumerating all available instances of database servers within the local network.
Public class DbEnumerator Exposes the GetEnumerator method, which supports a simple iteration over a collection by a .NET Framework data provider.
Public class DbException The base class for all exceptions thrown on behalf of the data source.
Public class DbMetaDataCollectionNames Provides a list of constants for the well-known MetaDataCollections: DataSourceInformation, DataTypes, MetaDataCollections, ReservedWords, and Restrictions.
Public class DbMetaDataColumnNames Provides 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 class DbParameter Represents a parameter to a DbCommand and optionally, its mapping to a DataSet column. For more information on parameters, see Configuring Parameters and Parameter Data Types.
Public class DbParameterCollection The base class for a collection of parameters relevant to a DbCommand.
Public class DbProviderConfigurationHandler Infrastructure. This class can be used by any provider to support a provider-specific configuration section.
Public class DbProviderFactories Represents a set of static methods for creating one or more instances of DbProviderFactory classes.
Public class DbProviderFactoriesConfigurationHandler Infrastructure. This type supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Public class DbProviderFactory Represents a set of methods for creating instances of a provider's implementation of the data source classes.
Public class DbProviderManifest Metadata Interface for all CLR types types
Public class DbProviderServices The factory for building command definitions; use the type of this object as the argument to the IServiceProvider.GetService method on the provider factory;
Public class DbProviderSpecificTypePropertyAttribute Identifies which provider-specific property in the strongly typed parameter classes is to be used when setting a provider-specific type.
Public class DbTransaction The base class for a transaction.
Public class DbXmlEnabledProviderManifest Represents a base class that implements the DbProviderManifest based on an XML definition. You can use the DbXmlEnabledProviderManifest class to obtain provider-specific information at runtime.
Public class EntityRecordInfo Provides access to entity metadata.
Public class RowUpdatedEventArgs Provides data for the RowUpdated event of a .NET Framework data provider.
Public class RowUpdatingEventArgs Provides the data for the RowUpdating event of a .NET Framework data provider.
Public class SchemaTableColumn Describes the column metadata of the schema for a database table.
Public class SchemaTableOptionalColumn Describes optional column metadata of the schema for a database table.

  Structure Description
Public structure FieldMetadata Provides access to field metadata for a DataRecordInfo object.

  Enumeration Description
Public enumeration CatalogLocation Indicates the position of the catalog name in a qualified table name in a text command.
Public enumeration GroupByBehavior Specifies the relationship between the columns in a GROUP BY clause and the non-aggregated columns in the select-list of a SELECT statement.
Public enumeration IdentifierCase Specifies how identifiers are treated by the data source when searching the system catalog.
Public enumeration SupportedJoinOperators Specifies what types of Transact-SQL join statements are supported by the data source.
© 2015 Microsoft