Chapter 9. Programming with ADO.NET

The framework database programming classes are referred to as ADO.NET. ADO.NET introduces the DataSet class that works with relational data in a relational manner while you are disconnected from any data source. You need not connect and update or query the database unless you have a specific reason for doing so. You can, of course, work in the traditional connected manner if you choose.

ADO.NET data providers [1] allow you to execute commands directly against the data source. Functionality is exposed directly without intermediary objects such as OLEDB, which stands between ADO and the data source. The .NET DataAdapter class models a data source as a set of database commands and a connection to that data source. ...

Get Application Development Using C# and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.