The Disconnected Database Scenario

One of the innovations that ADO.NET introduces is working in the disconnected manner. The DataSet class implements an in-memory lightweight database. You can fill the DataSet with the information from the database to manipulate your data inside the DataSet without being connected and propagate the changes to the database server as necessary.

When working with DataSet, you populate it with the DataTable class objects that represent tables. You may have several tables inside one DataSet. This way you may even build in-memory relational databases.

The DataSet and DataTable classes are independent of any data provider. Therefore, we need an adapter, which will mediate between our DataSet objects and database server. ...

Get Programming PERL in the .NET Environment now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.