An Overview of ADO.NET

In ADO.NET, components are categorized into one of two categories: data manipulation and access through direct communication to a database, and data manipulation and access against in-memory copies of data (generated from a variety of different sources). Data providers supply the direct communication pipeline; they function as a data manipulation layer that sits between your code and a specific underlying data source. The DataSet component is responsible for allowing in-memory representations of both data and data schema.

Data Manipulation with Data Providers

As we have said, a data provider implements a layer of technology between your code and a database. Data providers are actually supplied by the .NET Framework and ...

Get Visual Basic® Programmer's Guide to the .NET Framework Class Library 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.