Chapter 29. Introducing Database Access with ADO.NET

ADO.NET is all about data access. It is the successor to ADO and defines an architecture for reading and writing data. At a high level, ADO.NET consists of two parts: .NET Data Providers and the DataSet.

There are two .NET Data Providers available as part of the .NET Framework Class Library. One is for SQL Server, and the other is for OLEDB. The SQL Server data provider is optimized for data access using SQL Server, while the OLEDB data provider is used to access data using any OLEDB database connection.

The DataSet supports disconnected access to data. A DataSet can be populated with data from a database, XML stream, or directly through your code. Once the data is loaded into a DataSet, it ...

Get Visual Basic® .NET by Example 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.