DataSet

Represents an in-memory cache of data.

The Wisej.NET DataSet component provides an in-memory cache of data retrieved from a data source, serving as a key component of the ADO.NET architecture. A DataSet contains a collection of DataTable objects that can be related through DataRelation objects. Data integrity is maintained using UniqueConstraint and ForeignKeyConstraint objects.

Features

Table Management

The DataTableCollection, accessed through the Tables property, contains the data tables. Table names are conditionally case-sensitive - if "mydatatable" exists but "Mydatatable" doesn't, searches become case-insensitive.

Data Relations

The DataRelationCollection enables navigation through table hierarchies, establishing relationships between tables in the DataSet.

XML Integration

The DataSet supports XML operations for data and schema:

• WriteXmlSchema: Save schema as XML

• WriteXml: Save both schema and data

• ReadXml: Load XML documents containing schema and data

For detailed information about working with DataSets, see:

• DataSets, DataTables, and DataViews

• Creating a DataTable

• System.Data.DataSet on MSDN