Database Reference
In-Depth Information
Figure 15-1 shows the data set architecture.
Figure 15-1.
Data set architecture
The architecture mirrors the logical design of a relational database. You'll see how to use data tables,
data rows, and data columns in this chapter.
A Brief Introduction to Data Adapters
When you first instantiate a data set, it contains no data. You obtain a populated data set by passing it to
a data adapter, which takes care of connection details and is a component of a data provider. A data set
isn't part of a data provider. It's like a bucket, ready to be filled with water, but it needs an external pipe
to let the water in. In other words, the data set needs a data adapter to populate it with data and to
support access to the data source.
Each data provider has its own data adapter in the same way that it has its own connection,
command, and data reader. Figure 15-2 depicts the interactions between the data set, data adapter, and
data source.
