Export (0) Print
Expand All
Expand Minimize

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.

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.

  ClassDescription
Public classConstraintRepresents a constraint that can be enforced on one or more DataColumn objects.
Public classConstraintCollectionRepresents a collection of constraints for a DataTable.
Public classConstraintExceptionRepresents the exception that is thrown when attempting an action that violates a constraint.
Public classDataColumnRepresents the schema of a column in a DataTable.
Public classDataColumnChangeEventArgsProvides data for the ColumnChanging event.
Public classDataColumnCollectionRepresents a collection of DataColumn objects for a DataTable.
Public classDataExceptionRepresents the exception that is thrown when errors are generated using ADO.NET components.
Public classDataRelationRepresents a parent/child relationship between two DataTable objects.
Public classDataRelationCollectionRepresents the collection of DataRelation objects for this DataSet.
Public classDataRowRepresents a row of data in a DataTable.
Public classDataRowBuilderInfrastructure. The DataRowBuilder type supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Public classDataRowChangeEventArgsProvides data for the RowChanged, RowChanging, OnRowDeleting, and OnRowDeleted events.
Public classDataRowCollectionRepresents a collection of rows for a DataTable.
Public classDataRowComparerReturns a singleton instance of the DataRowComparer<TRow> class.
Public classDataRowComparer<TRow>Compares two DataRow objects for equivalence by using value-based comparison.
Public classDataRowExtensionsDefines the extension methods to the DataRow class. This is a static class.
Public classDataRowViewRepresents a customized view of a DataRow.
Public classDataSetRepresents an in-memory cache of data.
Public classDataSetSchemaImporterExtensionThis member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
Public classDataSysDescriptionAttribute Obsolete. Marks a property, event, or extender with a description. Visual designers can display this description when referencing the member.
Public classDataTableRepresents one table of in-memory data.
Public classDataTableClearEventArgsProvides data for the Clear method.
Public classDataTableCollectionRepresents the collection of tables for the DataSet.
Public classDataTableExtensionsDefines the extension methods to the DataTable class. DataTableExtensions is a static class.
Public classDataTableNewRowEventArgsProvides data for the NewRow method.
Public classDataTableReaderThe DataTableReader obtains the contents of one or more DataTable objects in the form of one or more read-only, forward-only result sets.
Public classDataViewRepresents a databindable, customized view of a DataTable for sorting, filtering, searching, editing, and navigation.
Public classDataViewManagerContains a default DataViewSettingCollection for each DataTable in a DataSet.
Public classDataViewSettingRepresents the default settings for ApplyDefaultSort, DataViewManager, RowFilter, RowStateFilter, Sort, and Table for DataViews created from the DataViewManager.
Public classDataViewSettingCollectionContains a read-only collection of DataViewSetting objects for each DataTable in a DataSet.
Public classDBConcurrencyExceptionThe exception that is thrown by the DataAdapter during an insert, update, or delete operation if the number of rows affected equals zero.
Public classDeletedRowInaccessibleExceptionRepresents the exception that is thrown when an action is tried on a DataRow that has been deleted.
Public classDuplicateNameExceptionRepresents the exception that is thrown when a duplicate database object name is encountered during an add operation in a DataSet -related object.
Public classEntityCommandCompilationExceptionRepresents errors that occur during command compilation; when a command tree could not be produced to represent the command text.
Public classEntityCommandExecutionExceptionRepresents errors that occur when the underlying storage provider could not execute the specified command. This exception usually wraps a provider-specific exception.
Public classEntityExceptionRepresents 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.
Public classEntityKeyProvides a durable reference to an object that is an instance of an entity type.
Public classEntityKeyMemberRepresents a key name and value pair that is part of an EntityKey.
Public classEntitySqlExceptionRepresents errors that occur when parsing Entity SQL command text. This exception is thrown when syntactic or semantic rules are violated.
Public classEnumerableRowCollectionRepresents 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. 
Public classEnumerableRowCollection<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.
Public classEnumerableRowCollectionExtensionsContains 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.
Public classEvaluateExceptionRepresents the exception that is thrown when the Expression property of a DataColumn cannot be evaluated.
Public classFillErrorEventArgsProvides data for the FillError event of a DbDataAdapter.
Public classForeignKeyConstraintRepresents 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.
Public classInRowChangingEventExceptionRepresents the exception that is thrown when you call the EndEdit method within the RowChanging event.
Public classInternalDataCollectionBaseProvides the base functionality for creating collections.
Public classInvalidCommandTreeExceptionThe exception that is thrown to indicate that a command tree is invalid.
Public classInvalidConstraintExceptionRepresents the exception that is thrown when incorrectly trying to create or access a relation.
Public classInvalidExpressionExceptionRepresents the exception that is thrown when you try to add a DataColumn that contains an invalid Expression to a DataColumnCollection.
Public classMappingExceptionThe exception that is thrown when mapping related service requests fail.
Public classMergeFailedEventArgsOccurs when a target and source DataRow have the same primary key value, and the EnforceConstraints property is set to true.
Public classMetadataExceptionThe exception that is thrown when metadata related service requests fails.
Public classMissingPrimaryKeyExceptionRepresents the exception that is thrown when you try to access a row in a table that has no primary key.
Public classNoNullAllowedExceptionRepresents the exception that is thrown when you try to insert a null value into a column where AllowDBNull is set to false.
Public classObjectNotFoundExceptionThe exception that is thrown when an object is not present.
Public classOperationAbortedExceptionThis exception is thrown when an ongoing operation is aborted by the user.
Public classOptimisticConcurrencyExceptionThe exception that is thrown when an optimistic concurrency violation occurs.
Public classOrderedEnumerableRowCollection<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.
Public classPropertyCollectionRepresents a collection of properties that can be added to DataColumn, DataSet, or DataTable.
Public classProviderIncompatibleExceptionThe exception that is thrown when the underlying data provider is incompatible with the Entity Framework.
Public classReadOnlyExceptionRepresents the exception that is thrown when you try to change the value of a read-only column.
Public classRowNotInTableExceptionRepresents the exception that is thrown when you try to perform an operation on a DataRow that is not in a DataTable.
Public classStateChangeEventArgsProvides data for the state change event of a .NET Framework data provider.
Public classStatementCompletedEventArgsProvides additional information for the StatementCompleted event.
Public classStrongTypingExceptionThe exception that is thrown by a strongly typed DataSet when the user accesses a DBNull value.
Public classSyntaxErrorExceptionRepresents the exception that is thrown when the Expression property of a DataColumn contains a syntax error.
Public classTypedDataSetGenerator Obsolete. Used to create a strongly typed DataSet.
Public classTypedDataSetGeneratorExceptionThe exception that is thrown when a name conflict occurs while generating a strongly typed DataSet.
Public classTypedTableBase<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.
Public classTypedTableBaseExtensionsContains the extension methods for the TypedTableBase<T> class.
Public classUniqueConstraintRepresents a restriction on a set of columns in which all values must be unique.
Public classUpdateExceptionThe exception that is thrown when modifications to object instances cannot be persisted to the data source.
Public classVersionNotFoundExceptionRepresents the exception that is thrown when you try to return a version of a DataRow that has been deleted.

  InterfaceDescription
Public interfaceIColumnMappingAssociates 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.
Public interfaceIColumnMappingCollectionContains a collection of DataColumnMapping objects, and is implemented by the DataColumnMappingCollection, which is used in common by .NET Framework data providers.
Public interfaceIDataAdapterAllows 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.
Public interfaceIDataParameterRepresents 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.
Public interfaceIDataParameterCollectionCollects 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.
Public interfaceIDataReaderProvides 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.
Public interfaceIDataRecordProvides access to the column values within each row for a DataReader, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbCommandRepresents an SQL statement that is executed while connected to a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbConnectionRepresents an open connection to a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbDataAdapterRepresents 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.
Public interfaceIDbDataParameterUsed by the Visual Basic .NET Data Designers to represent a parameter to a Command object, and optionally, its mapping to DataSet columns.
Public interfaceIDbTransactionRepresents a transaction to be performed at a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIExtendedDataRecordProvides access to the column values within each row of a DbDataRecord for a DbDataReader.
Public interfaceITableMappingAssociates 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.
Public interfaceITableMappingCollectionContains a collection of TableMapping objects, and is implemented by the DataTableMappingCollection, which is used in common by .NET Framework data providers.

  DelegateDescription
Public delegateDataColumnChangeEventHandlerRepresents the method that will handle the ColumnChanging event.
Public delegateDataRowChangeEventHandlerRepresents the method that will handle the RowChanging, RowChanged, RowDeleting, and RowDeleted events of a DataTable.
Public delegateDataTableClearEventHandlerRepresents the method that handles the Clear method.
Public delegateDataTableNewRowEventHandlerRepresents the method that handles the NewRow method.
Public delegateFillErrorEventHandlerRepresents the method that will handle the FillError event.
Public delegateMergeFailedEventHandlerRepresents the method that will handle the MergeFailed event.
Public delegateStateChangeEventHandlerRepresents the method that will handle the StateChange event.
Public delegateStatementCompletedEventHandlerThe delegate type for the event handlers of the StatementCompleted event.

  EnumerationDescription
Public enumerationAcceptRejectRuleDetermines the action that occurs when the AcceptChanges or RejectChanges method is invoked on a DataTable with a ForeignKeyConstraint.
Public enumerationCommandBehaviorProvides a description of the results of the query and its effect on the database.
Public enumerationCommandTypeSpecifies how a command string is interpreted.
Public enumerationConflictOptionSpecifies how conflicting changes to the data source will be detected and resolved.
Public enumerationConnectionStateDescribes the current state of the connection to a data source.
Public enumerationDataRowActionDescribes an action performed on a DataRow.
Public enumerationDataRowStateGets the state of a DataRow object.
Public enumerationDataRowVersionDescribes the version of a DataRow.
Public enumerationDataSetDateTimeDescribes the serialization format for DateTime columns in a DataSet.
Public enumerationDataViewRowStateDescribes the version of data in a DataRow.
Public enumerationDbTypeSpecifies the data type of a field, a property, or a Parameter object of a .NET Framework data provider.
Public enumerationEntityStateThe state of an entity object.
Public enumerationIsolationLevelSpecifies the transaction locking behavior for the connection.
Public enumerationKeyRestrictionBehaviorIdentifies a list of connection string parameters identified by the KeyRestrictions property that are either allowed or not allowed.
Public enumerationLoadOptionControls how the values from the data source will be applied to existing rows when using the Load or Load method.
Public enumerationMappingTypeSpecifies how a DataColumn is mapped.
Public enumerationMissingMappingActionDetermines the action that occurs when a mapping is missing from a source table or a source column.
Public enumerationMissingSchemaActionSpecifies the action to take when adding data to the DataSet and the required DataTable or DataColumn is missing.
Public enumerationParameterDirectionSpecifies the type of a parameter within a query relative to the DataSet.
Public enumerationPropertyAttributes Obsolete. Specifies the attributes of a property.
Public enumerationRuleIndicates the action that occurs when a ForeignKeyConstraint is enforced.
Public enumerationSchemaSerializationModeIndicates the schema serialization mode for a typed DataSet.
Public enumerationSchemaTypeSpecifies how to handle existing schema mappings when performing a FillSchema operation.
Public enumerationSerializationFormatDetermines the serialization format for a DataSet.
Public enumerationSqlDbTypeSpecifies SQL Server-specific data type of a field, property, for use in a SqlParameter.
Public enumerationStatementTypeSpecifies the type of SQL query to be used by the OleDbRowUpdatedEventArgs, OleDbRowUpdatingEventArgs, SqlRowUpdatedEventArgs, or SqlRowUpdatingEventArgs class.
Public enumerationUpdateRowSourceSpecifies how query command results are applied to the row being updated.
Public enumerationUpdateStatusSpecifies the action to take with regard to the current and remaining rows during an Update.
Public enumerationXmlReadModeSpecifies how to read XML data and a relational schema into a DataSet.
Public enumerationXmlWriteModeSpecifies how to write XML data and a relational schema from a DataSet.

Community Additions

ADD
Show:
© 2014 Microsoft