System.Data Namespace

Represents a constraint that can be enforced on one or more DataColumn objects.

Represents a collection of constraints for a DataTable.

Represents the exception that is thrown when attempting an action that violates a constraint.

Represents the schema of a column in a DataTable.

Provides data for the ColumnChanging event.

Represents a collection of DataColumn objects for a DataTable.

Represents the exception that is thrown when errors are generated using ADO.NET components.

Provides extension methods for DbDataReader.

Represents a parent/child relationship between two DataTable objects.

Represents the collection of DataRelation objects for this DataSet.

Represents a row of data in a DataTable.

The DataRowBuilder type supports the .NET infrastructure and is not intended to be used directly from your code.

Provides data for the RowChanged, RowChanging, OnRowDeleting(DataRowChangeEventArgs), and OnRowDeleted(DataRowChangeEventArgs) events.

Represents a collection of rows for a DataTable.

Returns a singleton instance of the DataRowComparer<TRow> class.

Compares two DataRow objects for equivalence by using value-based comparison.

Defines the extension methods to the DataRow class. This is a static class.

Represents a customized view of a DataRow.

Represents an in-memory cache of data.

Marks a property, event, or extender with a description. Visual designers can display this description when referencing the member.

Represents one table of in-memory data.

Provides data for the Clear() method.

Represents the collection of tables for the DataSet.

Defines the extension methods to the DataTable class. DataTableExtensions is a static class.

Provides data for the NewRow() method.

The DataTableReader obtains the contents of one or more DataTable objects in the form of one or more read-only, forward-only result sets.

Represents a databindable, customized view of a DataTable for sorting, filtering, searching, editing, and navigation. The DataView does not store data, but instead represents a connected view of its corresponding DataTable. Changes to the DataView's data will affect the DataTable. Changes to the DataTable's data will affect all DataViews associated with it.

Contains a default DataViewSettingCollection for each DataTable in a DataSet.

Represents the default settings for ApplyDefaultSort, DataViewManager, RowFilter, RowStateFilter, Sort, and Table for DataViews created from the DataViewManager.

Contains a read-only collection of DataViewSetting objects for each DataTable in a DataSet.

The exception that is thrown by the DataAdapter during an insert, update, or delete operation if the number of rows affected equals zero.

Represents the exception that is thrown when an action is tried on a DataRow that has been deleted.

Represents the exception that is thrown when a duplicate database object name is encountered during an add operation in a DataSet -related object.

Represents a collection of DataRow objects returned from a LINQ to DataSet query. This API supports the .NET infrastructure and is not intended to be used directly from your code.

Represents a collection of DataRow objects returned from a query.

Contains the extension methods for the data row collection classes.

Represents the exception that is thrown when the Expression property of a DataColumn cannot be evaluated.

Provides data for the FillError event of a DbDataAdapter.

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.

Represents the exception that is thrown when you call the EndEdit() method within the RowChanging event.

Provides the base functionality for creating collections.

Represents the exception that is thrown when incorrectly trying to create or access a relation.

Represents the exception that is thrown when you try to add a DataColumn that contains an invalid Expression to a DataColumnCollection.

Occurs when a target and source DataRow have the same primary key value, and the EnforceConstraints property is set to true.

Represents the exception that is thrown when you try to access a row in a table that has no primary key.

Represents the exception that is thrown when you try to insert a null value into a column where AllowDBNull is set to false.

Represents a collection of ordered DataRow objects returned from a query.

Represents a collection of properties that can be added to DataColumn, DataSet, or DataTable.

Represents the exception that is thrown when you try to change the value of a read-only column.

Represents the exception that is thrown when you try to perform an operation on a DataRow that is not in a DataTable.

Provides data for the state change event of a .NET data provider.

Provides additional information for the StatementCompleted event.

The exception that is thrown by a strongly typed DataSet when the user accesses a DBNull value.

Represents the exception that is thrown when the Expression property of a DataColumn contains a syntax error.

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.

Contains the extension methods for the TypedTableBase<T> class.

Represents a restriction on a set of columns in which all values must be unique.

Represents the exception that is thrown when you try to return a version of a DataRow that has been deleted.

Associates a data source column with a DataSet column, and is implemented by the DataColumnMapping class, which is used in common by .NET data providers.

Contains a collection of DataColumnMapping objects, and is implemented by the DataColumnMappingCollection, which is used in common by .NET data providers.

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 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.

Represents a parameter to a Command object, and optionally, its mapping to DataSet columns; and is implemented by .NET data providers that access data sources.

Collects all parameters relevant to a Command object and their mappings to DataSet columns, and is implemented by .NET data providers that access data sources.

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 data providers that access relational databases.

Provides access to the column values within each row for a DataReader, and is implemented by .NET data providers that access relational databases.

Represents an SQL statement that is executed while connected to a data source, and is implemented by .NET data providers that access relational databases.

Represents an open connection to a data source, and is implemented by .NET data providers that access relational databases.

Represents a set of command-related properties that are used to fill the DataSet and update a data source, and is implemented by .NET data providers that access relational databases.

Used by the Visual Basic .NET Data Designers to represent a parameter to a Command object, and optionally, its mapping to DataSet columns.

Represents a transaction to be performed at a data source, and is implemented by .NET data providers that access relational databases.

Associates a source table with a table in a DataSet, and is implemented by the DataTableMapping class, which is used in common by .NET data providers.

Contains a collection of TableMapping objects, and is implemented by the DataTableMappingCollection, which is used in common by .NET data providers.

Determines the action that occurs when the AcceptChanges() or RejectChanges() method is invoked on a DataTable with a ForeignKeyConstraint.

Provides a description of the results of the query and its effect on the database.

Specifies how a command string is interpreted.

Specifies how conflicting changes to the data source will be detected and resolved.

Describes the current state of the connection to a data source.

Describes an action performed on a DataRow.

Gets the state of a DataRow object.

Describes the version of a DataRow.

Describes the serialization format for DateTime columns in a DataSet.

Describes the version of data in a DataRow.

Specifies the data type of a field, a property, or a Parameter object of a .NET data provider.

Specifies the transaction locking behavior for the connection.

Identifies a list of connection string parameters identified by the KeyRestrictions property that are either allowed or not allowed.

Controls how the values from the data source will be applied to existing rows when using the Load or Load method.

Specifies how a DataColumn is mapped.

Determines the action that occurs when a mapping is missing from a source table or a source column.

Specifies the action to take when adding data to the DataSet and the required DataTable or DataColumn is missing.

Specifies the type of a parameter within a query relative to the DataSet.

Indicates the action that occurs when a ForeignKeyConstraint is enforced.

Indicates the schema serialization mode for a typed DataSet.

Specifies how to handle existing schema mappings when performing a FillSchema(DataSet, SchemaType) operation.

Determines the serialization format for a DataSet.

Specifies SQL Server-specific data type of a field, property, for use in a SqlParameter.

Specifies the type of SQL query to be used by the OleDbRowUpdatedEventArgs, OleDbRowUpdatingEventArgs, SqlRowUpdatedEventArgs, or SqlRowUpdatingEventArgs class.

Specifies how query command results are applied to the row being updated.

Specifies the action to take with regard to the current and remaining rows during an Update(DataSet).

Specifies how to read XML data and a relational schema into a DataSet.

Specifies how to write XML data and a relational schema from a DataSet.

Represents the method that will handle the ColumnChanging event.

Represents the method that will handle the RowChanging, RowChanged, RowDeleting, and RowDeleted events of a DataTable.

Represents the method that handles the Clear() method.

Represents the method that handles the NewRow() method.

Represents the method that will handle the FillError event.

Represents the method that will handle the MergeFailed event.

Represents the method that will handle the StateChange event.

The delegate type for the event handlers of the StatementCompleted event.