|
The role of the ADO.NET DataAdapter.
By William Vaughn
Published: 1 September 2003
The ADO.NET DataAdapter and serialisable
DataTable are the hinge pins of ADO.NET's
disconnected architecture. These classes provide a
way to expose one or more rowsets and a mechanism to
update the data. This is a new mechanism for data
access developers writing code for all application
architectures. This article walks you through
several data access strategies that take advantage
of features implemented by the DataAdapter. Note
that the DataAdapter is implemented by each of the
.NET Data Providers included in the Windows .NET
Framework. For example, in the SqlClient .NET Data
Provider, the DataAdapter is implemented as the
System.Data.SqlClient.SqlDataAdapter. This article
discusses the DataAdapter in terms that apply to all
of the Framework implementation.
The DataAdapter is not really a new idea born
with ADO... (click
here for the rest of part one of the article)
|
The Role of the ADO.NET DataAdapter – Part 2: when user meets data |
|
|
In last month's VSJ I
discussed how to setup
the DataAdapter using a
variety of techniques to
construct and populate
one or more DataTable
objects associated with
a chosen DataSet. Once
the data has been loaded
into client memory, the
next tasks are to
display the data to the
user (if necessary),
accept any changes to
the data, record them in
the in-memory DataTable,
and eventually, post
these changes to the
source database. This
article outlines each of
these steps and focuses
special attention on
updating data on the
server. |
|
|
|
