Chapter 34. The System.Data Namespace

The System.Data namespace represents the core of ADO.NET. It contains the fundamental data container classes such as DataSet . Every DataSet contains a collection of DataTable instances. Each DataTable holds a collection of DataRow objects, each of which contains the data for a single row. These data classes are independent of any ADO.NET provider. They simply store disconnected data. In addition, the DataSet also contains objects that describe structural information about your data. This structural information, which is also known as metadata, includes column-specific settings such as data type (found in DataColumn ), foreign key and unique column constraints (represented by ForeignKeyConstraint and UniqueConstraint ), and relations that link columns in different tables (represented by DataRelation ).

Taken together, these objects act like an in-memory relational database, complete with versioning, column and table information, XML output, and automatic enforcement of identity and relational integrity rules. However, these classes are only part of the System.Data namespace. You'll also find the interfaces that must be implemented by every ADO.NET provider. These interfaces define connections (IDbConnection ), commands (IDbCommand ), data readers (IDataReader ), parameters (IDbDataParameter ), transactions (IDbTransaction ), and data adapters (IDbDataAdapter and IDataAdapter ). These interfaces aren't just a low-level part of ADO.NET. You'll need to use them if you want to write generic provider-agnostic data code (as described in Chapter 2). You'll also need to use them to create your own custom provider.

Figure 34-1 shows many of the types in this namespace. Figure 34-2 highlights the exceptions, delegates, and event arguments. See Figure 34-3 for components and other types.

Figure 34-1. The System.Data namespace

figs/adonet_3401.gif

Part I: ADO.NET Tutorial

Part II: ADO.NET Core Classes

Part III: API Quick Reference

Chapter 32. How to Use This Quick Reference

Chapter 33. Converting from C# to VB Syntax

Chapter 34. The System.Data Namespace

''AcceptRejectRule'' ''serializable'

''CommandBehavior'' ''serializable, flag'

''CommandType'' ''serializable'

''ConnectionState'' ''serializable, flag'

''Constraint'' ''serializable'

''ConstraintCollection'' ''serializable'

''ConstraintException'' ''serializable'

''DataColumn'' ''diposable'

''DataColumnChangeEventArgs'' '''

''DataColumnChangeEventHandler'' ''serializable'

''DataColumnCollection'' ''serializable'

''DataException'' ''serializable'

''DataRelation'' ''serializable'

''DataRelationCollection'' ''serializable'

''DataRow'' ''serializable'

''DataRowAction'' ''serializable, flag'

''DataRowChangeEventArgs'' '''

''DataRowChangeEventHandler'' ''serializable'

''DataRowCollection'' ''serializable'

''DataRowState'' ''serializable, flag'

''DataRowVersion'' ''serializable'

''DataRowView'' '''

''DataSet'' ''serializable, diposable'

''DataSysDescriptionAttribute'' '''

''DataTable'' ''serializable, disposable'

''DataTableCollection'' ''serializable'

''DataView'' ''disposable'

''DataViewManager'' ''disposable'

''DataViewRowState'' ''serializable, flag'

''DataViewSetting'' ''serializable'

''DataViewSettingCollection'' ''serializable'

''DBConcurrencyException'' ''serializable'

''DbType'' ''serializable'

''DeletedRowInaccessibleException'' ''serializable'

''DuplicateNameException'' ''serializable'

''EvaluateException'' ''serializable'

''FillErrorEventArgs'' '''

''FillErrorEventHandler'' ''serializable'

''ForeignKeyConstraint'' ''serializable'

''IColumnMapping'' '''

''IColumnMappingCollection'' '''

''IDataAdapter'' '''

''IDataParameter'' '''

''IDataParameterCollection'' '''

''IDataReader'' ''dispoable'

''IDataRecord'' '''

''IDbCommand'' ''diposable'

''IDbConnection'' ''disposable'

''IDbDataAdapter'' '''

''IDbDataParameter'' '''

''IDbTransaction'' ''disposable'

''InRowChangingEventException'' ''serializable'

''InternalDataCollectionBase'' '''

''InvalidConstraintException'' ''serializable'

''InvalidExpressionException'' ''serializable'

''IsolationLevel'' ''serializable, flag'

''ITableMapping'' '''

''ITableMappingCollection'' '''

''MappingType'' ''serializable'

''MergeFailedEventArgs'' '''

''MergeFailedEventHandler'' ''serializable'

''MissingMappingAction'' ''serializable'

''MissingPrimaryKeyException'' ''serializable'

''MissingSchemaAction'' ''serializable'

''NoNullAllowedException'' ''serializable'

''ParameterDirection'' ''serializable'

''PropertyAttributes'' ''serializable, flag'

''PropertyCollection'' '''

''ReadOnlyException'' ''serializable'

''RowNotInTableException'' ''serializable'

''Rule'' ''serializable'

''SchemaType'' ''serializable'

''SqlDbType'' ''serializable'

''StateChangeEventArgs'' '''

''StateChangeEventHandler'' ''serializable'

''StatementType'' ''serializable'

''StrongTypingException'' ''serializable'

''SyntaxErrorException'' ''serializable'

''TypedDataSetGenerator'' '''

''TypedDataSetGeneratorException'' ''serializable'

''UniqueConstraint'' ''serializable'

''UpdateRowSource'' ''serializable'

''UpdateStatus'' ''serializable'

''VersionNotFoundException'' ''serializable'

''XmlReadMode'' ''serializable'

''XmlWriteMode'' ''serializable'

Chapter 35. The System.Data.Common Namespace

Chapter 36. The System.Data.SqlClient Namespace

Chapter 37. The System.Data.OleDb Namespace

Chapter 38. The System.Data.SqlTypes Namespace

Part IV: Appendixes

Type, Method, Property, and Field Index