System.Data 命名空间
类
Constraint |
表示可在一个或多个 DataColumn 对象上强制执行的约束。Represents a constraint that can be enforced on one or more DataColumn objects. |
ConstraintCollection |
表示 DataTable 的约束集合。Represents a collection of constraints for a DataTable. |
ConstraintException |
表示在尝试执行违反约束的操作时引发的异常。Represents the exception that is thrown when attempting an action that violates a constraint. |
DataColumn |
表示 DataTable 中的列的架构。Represents the schema of a column in a DataTable. |
DataColumnChangeEventArgs |
为 ColumnChanging 事件提供数据。Provides data for the ColumnChanging event. |
DataColumnCollection |
表示 DataColumn 的 DataTable 对象的集合。Represents a collection of DataColumn objects for a DataTable. |
DataException |
表示使用 ADO.NET 组件发生错误时引发的异常。Represents the exception that is thrown when errors are generated using ADO.NET components. |
DataReaderExtensions |
为 DbDataReader 提供扩展方法。Provides extension methods for DbDataReader. |
DataRelation |
表示两个 DataTable 对象之间的父/子关系。Represents a parent/child relationship between two DataTable objects. |
DataRelationCollection |
表示此 DataRelation 的 DataSet 对象的集合。Represents the collection of DataRelation objects for this DataSet. |
DataRow |
表示 DataTable 中的一行数据。Represents a row of data in a DataTable. |
DataRowBuilder |
|
DataRowChangeEventArgs |
为 RowChanged、RowChanging、OnRowDeleting(DataRowChangeEventArgs) 和 OnRowDeleted(DataRowChangeEventArgs) 事件提供数据。Provides data for the RowChanged, RowChanging, OnRowDeleting(DataRowChangeEventArgs), and OnRowDeleted(DataRowChangeEventArgs) events. |
DataRowCollection |
表示 DataTable 的行的集合。Represents a collection of rows for a DataTable. |
DataRowComparer |
返回 DataRowComparer<TRow> 类的单一实例。Returns a singleton instance of the DataRowComparer<TRow> class. |
DataRowComparer<TRow> |
通过使用基于值的比较来比较两个 DataRow 对象是否等值。Compares two DataRow objects for equivalence by using value-based comparison. |
DataRowExtensions |
定义 DataRow 类的扩展方法。Defines the extension methods to the DataRow class. 这是一个静态类。This is a static class. |
DataRowView |
表示 DataRow 的自定义视图。Represents a customized view of a DataRow. |
DataSet |
表示数据在内存中的缓存。Represents an in-memory cache of data. |
DataSetSchemaImporterExtension |
此成员支持 .NET Framework 结构,不能在代码中直接使用。This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
DataSysDescriptionAttribute |
用说明来标记属性、事件或扩展程序。Marks a property, event, or extender with a description. 可视化设计器在引用成员时可显示该说明。Visual designers can display this description when referencing the member. |
DataTable |
表示内存中数据的一个表。Represents one table of in-memory data. |
DataTableClearEventArgs | |
DataTableCollection |
表示 DataSet 的表的集合。Represents the collection of tables for the DataSet. |
DataTableExtensions |
定义 DataTable 类的扩展方法。Defines the extension methods to the DataTable class. DataTableExtensions 是一个静态类。DataTableExtensions is a static class. |
DataTableNewRowEventArgs | |
DataTableReader |
DataTableReader 以一个或多个只读、只进结果集的形式获取一个或多个 DataTable 对象的内容。The DataTableReader obtains the contents of one or more DataTable objects in the form of one or more read-only, forward-only result sets. |
DataView |
代表 DataTable 的可绑定数据的自定义视图,它用于排序、筛选、搜索、编辑和导航。Represents a databindable, customized view of a DataTable for sorting, filtering, searching, editing, and navigation. DataView 不存储数据,而改为表示对应的 DataTable 的连接视图。The DataView does not store data, but instead represents a connected view of its corresponding DataTable. 更改 DataView 的数据会影响 DataTable。Changes to the DataView's data will affect the DataTable. 更改 DataTable 的数据将影响与之关联的所有 DataView。Changes to the DataTable's data will affect all DataViews associated with it. |
DataViewManager |
在 DataSet 中包含每个 DataTable 的默认 DataViewSettingCollection。Contains a default DataViewSettingCollection for each DataTable in a DataSet. |
DataViewSetting |
表示从 ApplyDefaultSort 创建的 DataView 的 DataViewManager、RowFilter、RowStateFilter、Sort、Table 和 DataViewManager 的默认设置。Represents the default settings for ApplyDefaultSort, DataViewManager, RowFilter, RowStateFilter, Sort, and Table for DataViews created from the DataViewManager. |
DataViewSettingCollection |
包含 DataViewSetting 中每个 DataTable 的 DataSet 对象的只读集合。Contains a read-only collection of DataViewSetting objects for each DataTable in a DataSet. |
DBConcurrencyException |
在插入、更新或删除操作过程中当受影响的行数等于零时由 DataAdapter 引发的异常。The exception that is thrown by the DataAdapter during an insert, update, or delete operation if the number of rows affected equals zero. |
DeletedRowInaccessibleException |
表示尝试在已删除的 DataRow 上执行操作时引发的异常。Represents the exception that is thrown when an action is tried on a DataRow that has been deleted. |
DuplicateNameException |
表示在 DataSet — 相关对象添加操作的过程中,遇到重复的数据库对象名称时引发的异常。Represents the exception that is thrown when a duplicate database object name is encountered during an add operation in a DataSet -related object. |
EntityCommandCompilationException |
表示命令编译过程中发生的错误;当无法生成命令树来表示命名文本时。Represents errors that occur during command compilation; when a command tree could not be produced to represent the command text. |
EntityCommandExecutionException |
表示当基础存储提供程序未能执行指定的命令时发生的错误。Represents errors that occur when the underlying storage provider could not execute the specified command. 此异常通常包装一个提供程序特定的异常。This exception usually wraps a provider-specific exception. |
EntityException |
表示 |
EntityKey |
提供对作为实体类型实例的对象的持久引用。Provides a durable reference to an object that is an instance of an entity type. |
EntityKeyMember |
表示作为 EntityKey 一部分的键名称和值对。Represents a key name and value pair that is part of an EntityKey. |
EntitySqlException |
表示分析 Entity SQL 命令文本时出现的错误。Represents errors that occur when parsing Entity SQL command text. 违反语法或语义规则时,引发此异常。This exception is thrown when syntactic or semantic rules are violated. |
EnumerableRowCollection |
表示从 LINQ to DataSet 查询返回的 DataRow 对象的集合。Represents a collection of DataRow objects returned from a LINQ to DataSet query. 此 API 支持 .NET Framework 基础结构,但不应在代码中直接使用。This API supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
EnumerableRowCollection<TRow> |
表示从查询返回的 DataRow 对象的集合。Represents a collection of DataRow objects returned from a query. |
EnumerableRowCollectionExtensions |
包含数据行集合类的扩展方法。Contains the extension methods for the data row collection classes. |
EvaluateException |
表示无法计算 DataColumn 的 Expression 属性时引发的异常。Represents the exception that is thrown when the Expression property of a DataColumn cannot be evaluated. |
FillErrorEventArgs |
为 DbDataAdapter 的 FillError 事件提供数据。Provides data for the FillError event of a DbDataAdapter. |
ForeignKeyConstraint |
表示删除或更新某个值或行时,对主键/外键关系中一组列强制进行的操作限制。Represents an action restriction enforced on a set of columns in a primary key/foreign key relationship when a value or row is either deleted or updated. |
InRowChangingEventException |
表示在 EndEdit() 事件中调用 RowChanging 方法时引发的异常。Represents the exception that is thrown when you call the EndEdit() method within the RowChanging event. |
InternalDataCollectionBase |
提供用于创建集合的基本功能。Provides the base functionality for creating collections. |
InvalidCommandTreeException |
引发来指示命令目录树无效的异常。The exception that is thrown to indicate that a command tree is invalid. 当前,在 Entity Framework 中的任何位置都不会引发此异常。This exception is currently not thrown anywhere in the Entity Framework. |
InvalidConstraintException |
表示在不正确地尝试创建或访问关系时引发的异常。Represents the exception that is thrown when incorrectly trying to create or access a relation. |
InvalidExpressionException |
表示在尝试将包含无效 DataColumn 的 Expression 添加到 DataColumnCollection 中时引发的异常。Represents the exception that is thrown when you try to add a DataColumn that contains an invalid Expression to a DataColumnCollection. |
MappingException |
当映射相关服务请求失败时引发的异常。The exception that is thrown when mapping related service requests fail. |
MergeFailedEventArgs |
在目标和源 |
MetadataException |
当元数据相关服务请求失败时引发的异常。The exception that is thrown when metadata related service requests fails. |
MissingPrimaryKeyException |
表示在尝试访问没有主键的表中的行时引发的异常。Represents the exception that is thrown when you try to access a row in a table that has no primary key. |
NoNullAllowedException |
表示在尝试将空值插入 AllowDBNull 设置为 |
ObjectNotFoundException |
当对象不存在时引发的异常。The exception that is thrown when an object is not present. |
OperationAbortedException |
当用户中止正在执行的某操作时,将引发此异常。This exception is thrown when an ongoing operation is aborted by the user. |
OptimisticConcurrencyException |
开放式并发冲突发生时引发的异常。The exception that is thrown when an optimistic concurrency violation occurs. |
OrderedEnumerableRowCollection<TRow> |
表示从查询返回的有序 DataRow 对象的集合。Represents a collection of ordered DataRow objects returned from a query. |
PropertyCollection |
表示可以添加到 DataColumn、DataSet 或 DataTable 的属性集合。Represents a collection of properties that can be added to DataColumn, DataSet, or DataTable. |
PropertyConstraintException |
属性限制异常类。Property constraint exception class. 注意此类有状态- 因此如果即使您更改其内部,它可能是重大更改。Note that this class has state - so if you change even its internals, it can be a breaking change. |
ProviderIncompatibleException |
基础数据提供程序与实体框架不兼容时引发的异常。The exception that is thrown when the underlying data provider is incompatible with the Entity Framework. |
ReadOnlyException |
表示在尝试更改只读列的值时引发的异常。Represents the exception that is thrown when you try to change the value of a read-only column. |
RowNotInTableException |
表示尝试在不位于 DataRow 中的 DataTable 上执行操作时引发的异常。Represents the exception that is thrown when you try to perform an operation on a DataRow that is not in a DataTable. |
StateChangeEventArgs |
为 .NET Framework 数据提供程序的状态更改事件提供数据。Provides data for the state change event of a .NET Framework data provider. |
StatementCompletedEventArgs |
为 StatementCompleted 事件提供附加信息。Provides additional information for the StatementCompleted event. |
StrongTypingException |
在用户访问 |
SyntaxErrorException |
表示当 DataColumn 的 Expression 属性包含语法错误时引发的异常。Represents the exception that is thrown when the Expression property of a DataColumn contains a syntax error. |
TypedDataSetGenerator | |
TypedDataSetGeneratorException |
当生成强类型 DataSet 的过程中发生名称冲突时引发的异常。The exception that is thrown when a name conflict occurs while generating a strongly typed DataSet. |
TypedTableBase<T> |
Visual Studio 和 XSD.exe .NET Framework 工具将此类型用作特型 DataTable 对象生成的基类,并且不能直接从代码中使用此类型。This type is used as a base class for typed-DataTable object generation by Visual Studio and the XSD.exe .NET Framework tool, and is not intended to be used directly from your code. |
TypedTableBaseExtensions |
包含 TypedTableBase<T> 类的扩展方法。Contains the extension methods for the TypedTableBase<T> class. |
UniqueConstraint |
表示对一组列的限制,列中的所有值必须是唯一的。Represents a restriction on a set of columns in which all values must be unique. |
UpdateException |
对对象实例的修改无法保持到数据源时引发的异常。The exception that is thrown when modifications to object instances cannot be persisted to the data source. |
VersionNotFoundException |
表示尝试返回已删除的 DataRow 版本时引发的异常。Represents the exception that is thrown when you try to return a version of a DataRow that has been deleted. |
接口
IColumnMapping |
将数据源列与 DataSet 列关联起来,并由 DataColumnMapping 类实现,这是 .NET Framework 数据提供程序通常使用的方法。Associates a data source column with a DataSet column, and is implemented by the DataColumnMapping class, which is used in common by .NET Framework data providers. |
IColumnMappingCollection |
包含一个 DataColumnMapping 对象的集合,并由 DataColumnMappingCollection 实现,这是由 .NET Framework 数据提供程序通常使用的方法。Contains a collection of DataColumnMapping objects, and is implemented by the DataColumnMappingCollection, which is used in common by .NET Framework data providers. |
IDataAdapter |
允许对象实现 DataAdapter,并且表示一组用于填充和更新 DataSet 及数据源的方法以及与映射操作有关的属性。Allows an object to implement a DataAdapter, and represents a set of methods and mapping action-related properties that are used to fill and update a DataSet and update a data source. IDbDataAdapter 实例针对作为(或类似于)具有文字命令(如 Transact-SQL)的关系数据库的数据源,而 IDataAdapter 实例可使用任何类型的数据源。IDbDataAdapter instances are for data sources that are (or resemble) relational databases with textual commands (like Transact-SQL), while IDataAdapter instances could can use any type of data source. |
IDataParameter |
表示 Command 对象的参数,也可以表示其到 DataSet 列的映射;并由访问数据源的 .NET Framework 数据提供程序实现。Represents a parameter to a Command object, and optionally, its mapping to DataSet columns; and is implemented by .NET Framework data providers that access data sources. |
IDataParameterCollection |
收集与 Command 对象相关的所有参数以及这些参数到 DataSet 列的映射,并由访问数据源的 .NET Framework 数据提供程序实现。Collects all parameters relevant to a Command object and their mappings to DataSet columns, and is implemented by .NET Framework data providers that access data sources. |
IDataReader |
提供一种读取结果集(通过对数据源执行命令获取)的一个或多个只进流的方法,并由访问关系数据库的.NET Framework 数据提供程序实现。Provides a means of reading one or more forward-only streams of result sets obtained by executing a command at a data source, and is implemented by .NET Framework data providers that access relational databases. |
IDataRecord |
为 |
IDbCommand |
表示连接到数据源时执行的 SQL 语句,并由访问关系数据库的 .NET Framework 数据提供程序实现。Represents an SQL statement that is executed while connected to a data source, and is implemented by .NET Framework data providers that access relational databases. |
IDbConnection |
表示一个与数据源的开放连接,并由访问关系数据库的 .NET Framework 数据提供程序实现。Represents an open connection to a data source, and is implemented by .NET Framework data providers that access relational databases. |
IDbDataAdapter |
表示一组与命令有关的属性,用于填充 DataSet 和更新数据源,由访问关系数据库的 .NET Framework 数据提供程序实现。Represents a set of command-related properties that are used to fill the DataSet and update a data source, and is implemented by .NET Framework data providers that access relational databases. |
IDbDataParameter |
由 Visual Basic.NET 数据设计器使用,用于表示命令对象的参数和(可选)该参数到 DataSet 列的映射。Used by the Visual Basic .NET Data Designers to represent a parameter to a Command object, and optionally, its mapping to DataSet columns. |
IDbTransaction |
表示要在数据源上执行的事务,并由访问关系数据库的 .NET Framework 数据提供程序实现。Represents a transaction to be performed at a data source, and is implemented by .NET Framework data providers that access relational databases. |
IExtendedDataRecord |
为 DbDataRecord 提供对 DbDataReader 的每行中的列值的访问。Provides access to the column values within each row of a DbDataRecord for a DbDataReader. |
ITableMapping |
将源表与 DataSet 中的表关联,并由 DataTableMapping 类实现,该类由 .NET Framework 数据提供程序共同使用。Associates a source table with a table in a DataSet, and is implemented by the DataTableMapping class, which is used in common by .NET Framework data providers. |
ITableMappingCollection |
包含 TableMapping 对象的集合,并由 DataTableMappingCollection(通常由 .NET Framework 数据提供程序共同使用)实现。Contains a collection of TableMapping objects, and is implemented by the DataTableMappingCollection, which is used in common by .NET Framework data providers. |
枚举
AcceptRejectRule |
确定在带有 AcceptChanges() 的 RejectChanges() 上调用 DataTable 或 ForeignKeyConstraint 方法时将发生的操作。Determines the action that occurs when the AcceptChanges() or RejectChanges() method is invoked on a DataTable with a ForeignKeyConstraint. |
CommandBehavior |
提供对查询结果和查询对数据库的影响的说明。Provides a description of the results of the query and its effect on the database. |
CommandType |
指定如何解释命令字符串。Specifies how a command string is interpreted. |
ConflictOption |
指定将如何检测和解决对数据源的相互冲突的更改。Specifies how conflicting changes to the data source will be detected and resolved. |
ConnectionState |
描述与数据源的连接的当前状态。Describes the current state of the connection to a data source. |
DataRowAction |
描述对 DataRow 执行的操作。Describes an action performed on a DataRow. |
DataRowState | |
DataRowVersion | |
DataSetDateTime |
介绍 DateTime 中 DataSet 列的序列化格式。Describes the serialization format for DateTime columns in a DataSet. |
DataViewRowState |
描述 DataRow 中的数据版本。Describes the version of data in a DataRow. |
DbType |
指定 .NET Framework 数据提供程序的字段、属性或 |
EntityState |
实体对象的状态。The state of an entity object. |
IsolationLevel |
指定连接的事务锁定行为。Specifies the transaction locking behavior for the connection. |
KeyRestrictionBehavior |
标识由 |
LoadOption |
当使用 Load 或 Load 方法时控制数据源中的值如何应用至现有行。Controls how the values from the data source will be applied to existing rows when using the Load or Load method. |
MappingType |
指定如何映射 DataColumn。Specifies how a DataColumn is mapped. |
MissingMappingAction |
确定源表或源列中缺少映射时发生的操作。Determines the action that occurs when a mapping is missing from a source table or a source column. |
MissingSchemaAction |
指定在将数据添加到 DataSet 而缺少要求的 DataTable 或 DataColumn 时要采取的操作。Specifies the action to take when adding data to the DataSet and the required DataTable or DataColumn is missing. |
ParameterDirection |
指定查询内的有关 DataSet 的参数的类型。Specifies the type of a parameter within a query relative to the DataSet. |
PropertyAttributes |
指定属性的特性。Specifies the attributes of a property. |
Rule |
指示强制执行 ForeignKeyConstraint 时发生的操作。Indicates the action that occurs when a ForeignKeyConstraint is enforced. |
SchemaSerializationMode |
指示类型化 DataSet 的架构序列化模式。Indicates the schema serialization mode for a typed DataSet. |
SchemaType |
指定在执行 FillSchema(DataSet, SchemaType) 操作时如何处理现有的架构映射。Specifies how to handle existing schema mappings when performing a FillSchema(DataSet, SchemaType) operation. |
SerializationFormat |
确定 DataSet 的序列化格式。Determines the serialization format for a DataSet. |
SqlDbType |
指定要用于 SqlParameter 中的字段和属性的 SQL Server 特定的数据类型。Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter. |
StatementType |
指定由 OleDbRowUpdatedEventArgs、OleDbRowUpdatingEventArgs、SqlRowUpdatedEventArgs 或 SqlRowUpdatingEventArgs 类使用的 SQL 查询的类型。Specifies the type of SQL query to be used by the OleDbRowUpdatedEventArgs, OleDbRowUpdatingEventArgs, SqlRowUpdatedEventArgs, or SqlRowUpdatingEventArgs class. |
UpdateRowSource |
指定如何将查询命令结果应用到正在更新的行。Specifies how query command results are applied to the row being updated. |
UpdateStatus |
指定在 Update(DataSet) 期间对当前行和其余行采取的操作。Specifies the action to take with regard to the current and remaining rows during an Update(DataSet). |
XmlReadMode |
指定如何将 XML 数据和关系架构读入 DataSet。Specifies how to read XML data and a relational schema into a DataSet. |
XmlWriteMode |
指定如何从 DataSet 写入 XML 数据和关系架构。Specifies how to write XML data and a relational schema from a DataSet. |
委托
DataColumnChangeEventHandler |
表示用来处理 ColumnChanging 事件的方法。Represents the method that will handle the ColumnChanging event. |
DataRowChangeEventHandler |
表示将处理 RowChanging 的 RowChanged、RowDeleting、RowDeleted 和 DataTable 事件的方法。Represents the method that will handle the RowChanging, RowChanged, RowDeleting, and RowDeleted events of a DataTable. |
DataTableClearEventHandler |
表示处理 Clear() 方法的方法。Represents the method that handles the Clear() method. |
DataTableNewRowEventHandler |
表示处理 NewRow() 方法的方法。Represents the method that handles the NewRow() method. |
FillErrorEventHandler |
表示用来处理 FillError 事件的方法。Represents the method that will handle the FillError event. |
MergeFailedEventHandler |
表示用来处理 MergeFailed 事件的方法。Represents the method that will handle the MergeFailed event. |
StateChangeEventHandler |
表示用来处理 StateChange 事件的方法。Represents the method that will handle the StateChange event. |
StatementCompletedEventHandler |
StatementCompleted 事件的事件处理程序的委托类型。The delegate type for the event handlers of the StatementCompleted event. |
注解
在断开连接(如 Internet)的情况下,ADO.NET 提供请求、更新和协调多层系统中的数据的工具。In a disconnected scenario such as the Internet, ADO.NET provides the tools to request, update, and reconcile data in multiple tier systems. ADO.NET 结构还实现在客户端应用程序中,如 Windows 窗体,或 ASP.NET 创建的 HTML 页。The ADO.NET architecture is also implemented in client applications, such as Windows Forms, or HTML pages created by ASP.NET.
ADO.NET 结构的核心是 DataSet 类。The centerpiece of the ADO.NET architecture is the DataSet class. 每个 DataSet 都可以包含多个 DataTable 对象,而每个 DataTable 都包含单个数据源(如 SQL Server)的数据。Each DataSet can contain multiple DataTable objects, with each DataTable containing data from a single data source, such as SQL Server.
每个 DataTable 都包含一个 DataColumnCollection-- DataColumn 对象的集合,该集合确定每个 DataTable 的架构。Each DataTable contains a DataColumnCollection--a collection of DataColumn objects--that determines the schema of each DataTable. DataType 属性确定 DataColumn 保存的数据的类型。The DataType property determines the type of data held by the DataColumn. 使用 ReadOnly 和 AllowDBNull 属性可以进一步确保数据完整性。The ReadOnly and AllowDBNull properties let you further guarantee data integrity. 使用 Expression 属性可以构造计算列。The Expression property lets you construct calculated columns.
如果 DataTable 参与同另一个 DataTable 的父/子关系,则通过将 DataRelation 添加到 DataRelationCollection 对象的 DataSet 来构造该关系。If a DataTable participates in a parent/child relationship with another DataTable, the relationship is constructed by adding a DataRelation to the DataRelationCollection of a DataSet object. 添加此关系后,将根据构造函数的参数设置自动创建 UniqueConstraint 和 ForeignKeyConstraint。When such a relation is added, a UniqueConstraint and a ForeignKeyConstraint are both created automatically, depending on the parameter settings for the constructor. UniqueConstraint 确保列中包含的值唯一。The UniqueConstraint guarantees that values that are contained in a column are unique. ForeignKeyConstraint 确定更改或删除主键值时将对子行或子列执行的操作。The ForeignKeyConstraint determines what action will happen to the child row or column when a primary key value is changed or deleted.
通过使用 System.Data.SqlClient 命名空间(用于 SQL Server 的 .NET Framework 数据提供程序)、System.Data.Odbc 命名空间(用 ODBC 的 .NET Framework 数据提供程序)、System.Data.OleDb 命名空间(用于 OLE DB 的 .NET Framework 数据提供程序)或 System.Data.OracleClient 命名空间(用于 Oracle 的 .NET Framework 数据提供程序),可以访问数据源从而用于 DataSet。Using the System.Data.SqlClient namespace (the.NET Framework Data Provider for SQL Server), the System.Data.Odbc namespace (the.NET Framework Data Provider for ODBC), the System.Data.OleDb namespace (the.NET Framework Data Provider for OLE DB), or the System.Data.OracleClient namespace (the .NET Framework Data Provider for Oracle), you can access a data source to use together with a DataSet. Each.NET Framework 数据提供程序都有一个相应DataAdapter用作数据源之间的桥梁和DataSet。Each.NET Framework data provider has a corresponding DataAdapter that you use as a bridge between a data source and a DataSet.