ADO.NET Explained

ADO.NET is a standards-based programming model for creating distributed, data-sharing applications.

If you have experience with ADO, you know that the RecordSet was the centerpiece of the model…where the rubber met the road, so to speak. In ADO.NET, the DataSet is the centerpiece. It's an in-memory copy of the data from a data store. Unlike an ADO RecordSet, a DataSet can contain any number of DataTables, each of which could represent the data from a database table or view. The DataSet resides in memory, disconnected from the original data store. In other words, the DataSet can exist without an active connection to the data store.

The underlying technology at work is XML, which is the persistence and transmission format for ...

Get Programming Data-Driven Web Applications with ASP.NET 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.