System.Data
TOC
Collapse the table of content
Expand the table of content

System.Data Namespace

 

The System.Data namespace provides access to classes that represent the ADO.NET architecture. ADO.NET lets you build components that efficiently manage data from multiple data sources.

ClassDescription
System_CAPS_pubclassConstraint

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

System_CAPS_pubclassConstraintCollection

Represents a collection of constraints for a DataTable.

System_CAPS_pubclassConstraintException

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

System_CAPS_pubclassDataColumn

Represents the schema of a column in a DataTable.

System_CAPS_pubclassDataColumnChangeEventArgs

Provides data for the ColumnChanging event.

System_CAPS_pubclassDataColumnCollection

Represents a collection of DataColumn objects for a DataTable.

System_CAPS_pubclassDataException

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

System_CAPS_pubclassDataRelation

Represents a parent/child relationship between two DataTable objects.

System_CAPS_pubclassDataRelationCollection

Represents the collection of DataRelation objects for this DataSet.

System_CAPS_pubclassDataRow

Represents a row of data in a DataTable.

System_CAPS_pubclassDataRowBuilder

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

System_CAPS_pubclassDataRowChangeEventArgs

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

System_CAPS_pubclassDataRowCollection

Represents a collection of rows for a DataTable.

System_CAPS_pubclassDataRowComparer

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

System_CAPS_pubclassDataRowComparer<TRow>

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

System_CAPS_pubclassDataRowExtensions

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

System_CAPS_pubclassDataRowView

Represents a customized view of a DataRow.

System_CAPS_pubclassDataSet

Represents an in-memory cache of data.

System_CAPS_pubclassDataSetSchemaImporterExtension

This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

System_CAPS_pubclassDataSysDescriptionAttribute

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

System_CAPS_pubclassDataTable

Represents one table of in-memory data.

System_CAPS_pubclassDataTableClearEventArgs

Provides data for the Clear method.

System_CAPS_pubclassDataTableCollection

Represents the collection of tables for the DataSet.

System_CAPS_pubclassDataTableExtensions

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

System_CAPS_pubclassDataTableNewRowEventArgs

Provides data for the NewRow method.

System_CAPS_pubclassDataTableReader

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

System_CAPS_pubclassDataView

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.

System_CAPS_pubclassDataViewManager

Contains a default DataViewSettingCollection for each DataTable in a DataSet.

System_CAPS_pubclassDataViewSetting

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

System_CAPS_pubclassDataViewSettingCollection

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

System_CAPS_pubclassDBConcurrencyException

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

System_CAPS_pubclassDeletedRowInaccessibleException

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

System_CAPS_pubclassDuplicateNameException

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

System_CAPS_pubclassEntityCommandCompilationException

Represents errors that occur during command compilation; when a command tree could not be produced to represent the command text.

System_CAPS_pubclassEntityCommandExecutionException

Represents errors that occur when the underlying storage provider could not execute the specified command. This exception usually wraps a provider-specific exception.

System_CAPS_pubclassEntityException

Represents Entity Framework-related errors that occur in the EntityClient namespace. The EntityException is the base class for all Entity Framework exceptions thrown by the EntityClient.

System_CAPS_pubclassEntityKey

Provides a durable reference to an object that is an instance of an entity type.

System_CAPS_pubclassEntityKeyMember

Represents a key name and value pair that is part of an EntityKey.

System_CAPS_pubclassEntitySqlException

Represents errors that occur when parsing Entity SQL command text. This exception is thrown when syntactic or semantic rules are violated.

System_CAPS_pubclassEnumerableRowCollection

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

System_CAPS_pubclassEnumerableRowCollection<TRow>

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

System_CAPS_pubclassEnumerableRowCollectionExtensions

Contains the extension methods for the data row collection classes. This API supports the .NET Framework infrastructure and is not intended to be used directly from your code.

System_CAPS_pubclassEvaluateException

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

System_CAPS_pubclassFillErrorEventArgs

Provides data for the FillError event of a DbDataAdapter.

System_CAPS_pubclassForeignKeyConstraint

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.

System_CAPS_pubclassInRowChangingEventException

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

System_CAPS_pubclassInternalDataCollectionBase

Provides the base functionality for creating collections.

System_CAPS_pubclassInvalidCommandTreeException

The exception that is thrown to indicate that a command tree is invalid. This exception is currently not thrown anywhere in the Entity Framework.

System_CAPS_pubclassInvalidConstraintException

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

System_CAPS_pubclassInvalidExpressionException

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

System_CAPS_pubclassMappingException

The exception that is thrown when mapping related service requests fail.

System_CAPS_pubclassMergeFailedEventArgs

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

System_CAPS_pubclassMetadataException

The exception that is thrown when metadata related service requests fails.

System_CAPS_pubclassMissingPrimaryKeyException

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

System_CAPS_pubclassNoNullAllowedException

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

System_CAPS_pubclassObjectNotFoundException

The exception that is thrown when an object is not present.

System_CAPS_pubclassOperationAbortedException

This exception is thrown when an ongoing operation is aborted by the user.

System_CAPS_pubclassOptimisticConcurrencyException

The exception that is thrown when an optimistic concurrency violation occurs.

System_CAPS_pubclassOrderedEnumerableRowCollection<TRow>

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

System_CAPS_pubclassPropertyCollection

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

System_CAPS_pubclassPropertyConstraintException

Property constraint exception class. Note that this class has state - so if you change even its internals, it can be a breaking change.

System_CAPS_pubclassProviderIncompatibleException

The exception that is thrown when the underlying data provider is incompatible with the Entity Framework.

System_CAPS_pubclassReadOnlyException

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

System_CAPS_pubclassRowNotInTableException

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

System_CAPS_pubclassStateChangeEventArgs

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

System_CAPS_pubclassStatementCompletedEventArgs

Provides additional information for the StatementCompleted event.

System_CAPS_pubclassStrongTypingException

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

System_CAPS_pubclassSyntaxErrorException

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

System_CAPS_pubclassTypedDataSetGenerator

Obsolete.Used to create a strongly typed DataSet.

System_CAPS_pubclassTypedDataSetGeneratorException

The exception that is thrown when a name conflict occurs while generating a strongly typed DataSet.

System_CAPS_pubclassTypedTableBase<T>

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.

System_CAPS_pubclassTypedTableBaseExtensions

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

System_CAPS_pubclassUniqueConstraint

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

System_CAPS_pubclassUpdateException

The exception that is thrown when modifications to object instances cannot be persisted to the data source.

System_CAPS_pubclassVersionNotFoundException

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

InterfaceDescription
System_CAPS_pubinterfaceIColumnMapping

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.

System_CAPS_pubinterfaceIColumnMappingCollection

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

System_CAPS_pubinterfaceIDataAdapter

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.

System_CAPS_pubinterfaceIDataParameter

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.

System_CAPS_pubinterfaceIDataParameterCollection

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.

System_CAPS_pubinterfaceIDataReader

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.

System_CAPS_pubinterfaceIDataRecord

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

System_CAPS_pubinterfaceIDbCommand

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.

System_CAPS_pubinterfaceIDbConnection

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

System_CAPS_pubinterfaceIDbDataAdapter

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.

System_CAPS_pubinterfaceIDbDataParameter

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

System_CAPS_pubinterfaceIDbTransaction

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

System_CAPS_pubinterfaceIExtendedDataRecord

Provides access to the column values within each row of a DbDataRecord for a DbDataReader.

System_CAPS_pubinterfaceITableMapping

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.

System_CAPS_pubinterfaceITableMappingCollection

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

DelegateDescription
System_CAPS_pubdelegateDataColumnChangeEventHandler

Represents the method that will handle the ColumnChanging event.

System_CAPS_pubdelegateDataRowChangeEventHandler

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

System_CAPS_pubdelegateDataTableClearEventHandler

Represents the method that handles the Clear method.

System_CAPS_pubdelegateDataTableNewRowEventHandler

Represents the method that handles the NewRow method.

System_CAPS_pubdelegateFillErrorEventHandler

Represents the method that will handle the FillError event.

System_CAPS_pubdelegateMergeFailedEventHandler

Represents the method that will handle the MergeFailed event.

System_CAPS_pubdelegateStateChangeEventHandler

Represents the method that will handle the StateChange event.

System_CAPS_pubdelegateStatementCompletedEventHandler

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

EnumerationDescription
System_CAPS_pubenumAcceptRejectRule

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

System_CAPS_pubenumCommandBehavior

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

System_CAPS_pubenumCommandType

Specifies how a command string is interpreted.

System_CAPS_pubenumConflictOption

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

System_CAPS_pubenumConnectionState

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

System_CAPS_pubenumDataRowAction

Describes an action performed on a DataRow.

System_CAPS_pubenumDataRowState

Gets the state of a DataRow object.

System_CAPS_pubenumDataRowVersion

Describes the version of a DataRow.

System_CAPS_pubenumDataSetDateTime

Describes the serialization format for DateTime columns in a DataSet.

System_CAPS_pubenumDataViewRowState

Describes the version of data in a DataRow.

System_CAPS_pubenumDbType

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

System_CAPS_pubenumEntityState

The state of an entity object.

System_CAPS_pubenumIsolationLevel

Specifies the transaction locking behavior for the connection.

System_CAPS_pubenumKeyRestrictionBehavior

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

System_CAPS_pubenumLoadOption

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

System_CAPS_pubenumMappingType

Specifies how a DataColumn is mapped.

System_CAPS_pubenumMissingMappingAction

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

System_CAPS_pubenumMissingSchemaAction

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

System_CAPS_pubenumParameterDirection

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

System_CAPS_pubenumPropertyAttributes

Obsolete.Specifies the attributes of a property.

System_CAPS_pubenumRule

Indicates the action that occurs when a ForeignKeyConstraint is enforced.

System_CAPS_pubenumSchemaSerializationMode

Indicates the schema serialization mode for a typed DataSet.

System_CAPS_pubenumSchemaType

Specifies how to handle existing schema mappings when performing a FillSchema operation.

System_CAPS_pubenumSerializationFormat

Determines the serialization format for a DataSet.

System_CAPS_pubenumSqlDbType

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

System_CAPS_pubenumStatementType

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

System_CAPS_pubenumUpdateRowSource

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

System_CAPS_pubenumUpdateStatus

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

System_CAPS_pubenumXmlReadMode

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

System_CAPS_pubenumXmlWriteMode

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

In a disconnected scenario such as the Internet, ADO.NET provides the tools to request, update, and reconcile data in multiple tier systems. The ADO.NET architecture is also implemented in client applications, such as Windows Forms, or HTML pages created by ASP.NET.

The centerpiece of the ADO.NET architecture is the DataSet class. Each DataSet can contain multiple DataTable objects, with each DataTable containing data from a single data source, such as SQL Server.

Each DataTable contains a DataColumnCollection--a collection of DataColumn objects--that determines the schema of each DataTable. The DataType property determines the type of data held by the DataColumn. The ReadOnly and AllowDBNull properties let you further guarantee data integrity. The Expression property lets you construct calculated columns.

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. When such a relation is added, a UniqueConstraint and a ForeignKeyConstraint are both created automatically, depending on the parameter settings for the constructor. The UniqueConstraint guarantees that values that are contained in a column are unique. The ForeignKeyConstraint determines what action will happen to the child row or column when a primary key value is changed or deleted.

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 data provider has a corresponding DataAdapter that you use as a bridge between a data source and a DataSet.

Return to top
Show:
© 2016 Microsoft