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