System.Data.Common Namespace
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Contains classes shared by .NET data providers.
Classes
| DataAdapter |
Represents a set of SQL commands and a database connection that are used to fill the DataSet and update the data source. |
| DataColumnMapping |
Contains a generic column mapping for an object that inherits from DataAdapter. This class cannot be inherited. |
| DataColumnMappingCollection |
Contains a collection of DataColumnMapping objects. |
| DataRecordInfo |
Provides access to information about the structural type and column information for a DbDataRecord. |
| 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. |
| DataTableMappingCollection |
A collection of DataTableMapping objects. This class cannot be inherited. |
| DbBatch |
Represents a batch of commands which can be executed against a data source in a single round trip. Provides a base class for database-specific classes that represent command batches. |
| DbBatchCommand |
Represents a single command within a DbBatch. A batch can be executed against a data source in a single round trip. |
| DbBatchCommandCollection |
The base class for a collection of instances of DbBatchCommand, contained in a DbBatch. |
| DbColumn |
Represents a column within a data source. |
| 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. |
| 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. |
| DbCommandDefinition |
Defines a cacheable command plan. |
| DbConnection |
Defines the core behavior of database connections and provides a base class for database-specific connections. |
| DbConnectionStringBuilder |
Provides a base class for strongly typed connection string builders. |
| 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. |
| DBDataPermission |
Enables a .NET data provider to help ensure that a user has a security level adequate for accessing data. |
| DBDataPermissionAttribute |
Associates a security action with a custom security attribute. |
| DbDataReader |
Reads a forward-only stream of rows from a data source. |
| DbDataReaderExtensions |
This class contains column schema extension methods for DbDataReader. |
| DbDataRecord |
Implements IDataRecord and ICustomTypeDescriptor, and provides data binding support for DbEnumerator. |
| DbDataSource |
Represents a data source which can be used to obtain open connections, and against which commands can be executed directly. |
| DbDataSourceEnumerator |
Provides a mechanism for enumerating all available instances of database servers within the local network. |
| DbEnumerator |
Exposes the GetEnumerator() method, which supports a simple iteration over a collection by a .NET data provider. |
| DbException |
The base class for all exceptions thrown on behalf of the data source. |
| DbMetaDataCollectionNames |
Provides a list of constants for the well-known MetaDataCollections: DataSourceInformation, DataTypes, MetaDataCollections, ReservedWords, and Restrictions. |
| 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. |
| 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. |
| DbParameterCollection |
The base class for a collection of parameters relevant to a DbCommand. |
| DbProviderConfigurationHandler |
This class can be used by any provider to support a provider-specific configuration section. |
| DbProviderFactories |
Represents a set of static methods for creating one or more instances of DbProviderFactory classes. |
| DbProviderFactoriesConfigurationHandler |
This type supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
| DbProviderFactory |
Represents a set of methods for creating instances of a provider's implementation of the data source classes. |
| DbProviderManifest |
Metadata Interface for all CLR types types. |
| 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. |
| DbProviderSpecificTypePropertyAttribute |
Identifies which provider-specific property in the strongly typed parameter classes is to be used when setting a provider-specific type. |
| DbTransaction |
Defines the core behavior of database transactions and provides a base class for database-specific transactions. |
| 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. |
| EntityRecordInfo |
Provides access to entity metadata. |
| RowUpdatedEventArgs |
Provides data for the |
| RowUpdatingEventArgs |
Provides the data for the RowUpdating event of a .NET data provider. |
| SchemaTableColumn |
Describes the column metadata of the schema for a database table. |
| SchemaTableOptionalColumn |
Describes optional column metadata of the schema for a database table. |
Structs
| FieldMetadata |
Provides access to field metadata for a DataRecordInfo object. |
Interfaces
| IDbColumnSchemaGenerator |
Generates a column schema. |
Enums
| CatalogLocation |
Indicates the position of the catalog name in a qualified table name in a text command. |
| 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. |
| IdentifierCase |
Specifies how identifiers are treated by the data source when searching the system catalog. |
| SupportedJoinOperators |
Specifies what types of Transact-SQL join statements are supported by the data source. |
Remarks
A .NET 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 data providers.
For conceptual information about how to use this namespace when programming with .NET Framework, see Writing Provider Independent Code with ADO.NET.
