System.Data.Common Namespace

System.Data.Common 命名空間包含 .NET Framework 資料提供者所共用的類別。 The System.Data.Common namespace contains classes shared by the .NET Framework data providers.

類別

DataAdapter

表示 SQL 命令集和資料庫連接,用來填入 DataSet 並更新資料來源。Represents a set of SQL commands and a database connection that are used to fill the DataSet and update the data source.

DataColumnMapping

含有繼承自 DataAdapter 之物件的泛用資料行對應。Contains a generic column mapping for an object that inherits from DataAdapter. 這個類別無法被繼承。This class cannot be inherited.

DataColumnMappingCollection

包含 DataColumnMapping 物件的集合。Contains a collection of DataColumnMapping objects.

DataRecordInfo

Provides access to information about the structural type and column information for a DbDataRecord.Provides access to information about the structural type and column information for a DbDataRecord.

DataTableMapping

含有來源資料表和 DataTable 之間對應關聯性 (Relationship) 的描述。Contains a description of a mapped relationship between a source table and a DataTable. 在填入 DataAdapter 時,DataSet 會使用這個類別。This class is used by a DataAdapter when populating a DataSet.

DataTableMappingCollection

DataTableMapping 物件的集合。A collection of DataTableMapping objects. 這個類別無法被繼承。This class cannot be inherited.

DbColumn

表示資料來源內的資料行。Represents a column within a data source.

DbCommand

表示要針對資料來源執行的 SQL 陳述式或預存程序。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

自動產生單一資料表命令,可用來調解對 DataSet 的變更和相關的資料庫。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

協助 IDbDataAdapter 介面的實作。Aids implementation of the IDbDataAdapter interface. DbDataAdapter 繼承者實作一組函式以提供強型別,但繼承大多數完整實作 DataAdapter 所需的功能。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

使 .NET Framework 資料提供者 (Data Provider) 可以確保使用者具有足夠的安全性等級來存取資料。Enables a .NET Framework 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

此類別包含 DbDataReader 的資料行結構描述擴充方法。This class contains column schema extension methods for DbDataReader.

DbDataRecord

實作 IDataRecordICustomTypeDescriptor,並為 DbEnumerator 提供資料繫結支援。Implements IDataRecord and ICustomTypeDescriptor, and provides data binding support for DbEnumerator.

DbDataSourceEnumerator

提供列舉區域網路內所有可用之資料庫伺服器執行個體的機制。Provides a mechanism for enumerating all available instances of database servers within the local network.

DbEnumerator

公開 GetEnumerator() 方法,該方法支援由 .NET Framework 資料提供者對集合執行簡單的反覆查看。Exposes the GetEnumerator() method, which supports a simple iteration over a collection by a .NET Framework data provider.

DbException

代表資料來源擲回之所有例外狀況的基底類別。The base class for all exceptions thrown on behalf of the data source.

DbMetaDataCollectionNames

提供已知 MetaDataCollections 的常數清單:DataSourceInformationDataTypesMetaDataCollectionsReservedWordsRestrictionsProvides a list of constants for the well-known MetaDataCollections: DataSourceInformation, DataTypes, MetaDataCollections, ReservedWords, and Restrictions.

DbMetaDataColumnNames

提供靜態值,用於 DataTable 中所含 MetaDataCollection 物件的資料行名稱。Provides static values that are used for the column names in the MetaDataCollection objects contained in the DataTable. DataTable 是由 GetSchema 方法建立。The DataTable is created by the GetSchema method.

DbParameter

表示 DbCommand 的參數及其對 DataSet 資料行的對應 (選擇性)。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

DbCommand 相關參數集合的基底類別。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

表示用於建立 DbProviderFactory 類別 (Class) 之一個或多個執行個體的一組靜態方法。Represents a set of static methods for creating one or more instances of DbProviderFactory classes.

DbProviderFactoriesConfigurationHandler

此類型支援 .NET Framework 基礎結構,並不能直接使用於您的程式碼中。This type supports the .NET Framework infrastructure and is not intended to be used directly from your code.

DbProviderFactory

表示用於建立資料來源類別 (class) 之提供者 (Provider) 實作 (Implementation) 執行個體的一組方法。Represents a set of methods for creating instances of a provider's implementation of the data source classes.

DbProviderManifest

所有 CLR 型別的中繼資料介面Metadata Interface for all CLR types types

DbProviderServices

用於建置命令定義的 Factory; 使用此物件的型別作為提供者 factory 的 IServiceProvider.GetService 方法的引數。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

設定特定提供者型別時,識別要使用強型別 (Strongly Typed) 參數類別 (Class) 中的哪個特定提供者屬性。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

表示依據 XML 定義實作 DbProviderManifest 的基底類別。Represents a base class that implements the DbProviderManifest based on an XML definition. 您可以在執行階段使用 DbXmlEnabledProviderManifest 類別取得提供者專屬資訊。You can use the DbXmlEnabledProviderManifest class to obtain provider-specific information at runtime.

EntityRecordInfo

提供實體中繼資料的存取。Provides access to entity metadata.

RowUpdatedEventArgs

為 .NET Framework 資料提供者 (Data Provider) 的 RowUpdated 事件提供資料。Provides data for the RowUpdated event of a .NET Framework data provider.

RowUpdatingEventArgs

為 .NET Framework Data Provider 的 RowUpdating 事件提供資料。Provides the data for the RowUpdating event of a .NET Framework data provider.

SchemaTableColumn

描述資料庫資料表之結構描述的資料行中繼資料 (Metadata)。Describes the column metadata of the schema for a database table.

SchemaTableOptionalColumn

描述資料庫資料表之結構描述的選擇性資料行中繼資料 (Metadata)。Describes optional column metadata of the schema for a database table.

結構

FieldMetadata

提供存取 DataRecordInfo 物件的欄位中繼資料。Provides access to field metadata for a DataRecordInfo object.

介面

IDbColumnSchemaGenerator

產生資料行結構描述。Generates a column schema.

列舉

CatalogLocation

表示文字命令之合格資料表名稱中類別目錄名稱的位置。Indicates the position of the catalog name in a qualified table name in a text command.

GroupByBehavior

指定 GROUP BY 子句中的資料行與 SELECT 陳述式 (Statement) 之 SELECT 清單中非彙總 (Non-aggregated) 資料行之間的關聯性 (Relationship)。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

指定在搜尋系統資料庫目錄 (Catalog) 時,資料來源如何處理識別項。Specifies how identifiers are treated by the data source when searching the system catalog.

SupportedJoinOperators

指定資料來源支援之 Transact-SQL join 陳述式的型別。Specifies what types of Transact-SQL join statements are supported by the data source.

備註

.NET Framework 資料提供者描述用來存取 Managed 空間中資料來源 (例如資料庫) 的類別集合。A .NET Framework data provider describes a collection of classes used to access a data source, such as a database, in the managed space. 支援的提供者包括 ODBC 的 .NET Framework 資料提供者、OLEDB 的 .NET Framework 資料提供者、Oracle 的 .NET Framework 資料提供者,以及 SQL Server 的 .NET Framework 資料提供者。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. System.Data.Common 中的類別目的是要為開發人員提供一種能針對所有 .NET Framework 資料提供者撰寫 ADO.NET 程式碼的方式。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.

如需如何使用.net Framework 進行程式設計時,請使用此命名空間的概念資訊,請參閱撰寫提供者獨立程式碼使用 ADO.NETFor conceptual information about how to use this namespace when programming with the.NET Framework, see Writing Provider Independent Code with ADO.NET.