|
ADO.NET |
|
ADO.NET is a set of classes that expose the data access services of the .NET Framework. ADO.NET is a natural evolution of ADO and is built around N-Tier application development. ADO.NET has been created with XML at its core.
The ADO.NET object model is composed of two central components: the connected layer, which consists of the classes that comprise the .NET Data Provider, and the disconnected layer, which is rooted in the DataSet.
.NET Data Providers includes the following components: the Connection object, the Command object, the DataReader, and the DataAdapter. The first two should be familiar to existing ADO programmers; they are used to open a connection to a data source and execute a command against it. The DataReader loosely corresponds to a forward-only, read-only recordset. It is a highly optimized, nonbuffering, firehose-style interface for getting the results of a query executed against the data source. The DataAdapter provides the bridge between the .NET Data Providers and the DataSet.
The DataSet is a local buffer of tables or a collection of disconnected recordsets.