Overview of the Data Model

The POCO DataSet data model is designed to provide a clean, predictable structure for working with tabular data in modern .NET applications. It is composed of independent but related layers, allowing data, schema, and metadata to be transported, displayed, or processed in a flexible and extensible way.

Core Concepts

• DataSet – the root container.
• DataTable – represents a logical table.
• DataRow – represents one row of data.
• ColumnMetadata – defines schema for each column.

Separation of Concerns

The model separates schema (ColumnMetadata) from data (DataRow) while linking them through the DataTable. This enables scenarios such as loading schema-only datasets, transporting data without schema, or mixing both depending on UI or service needs.

• Understanding DataSet, DataTable, and DataRow
• Understanding Column Metadata
• Supported Data Types
• Nullability Model
• Primary Keys
• Relationships between Tables

Table of Content POCO DataSet