Skip to main content

DataSet

WATCH & LEARN0:48 · Animated tutorial
7 scenesPlay, pause, or scrub at your own pace

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
info

For detailed information about working with DataSets, see: