O'Reilly logo

C# for Java Developers by Adam Freeman, Allen Jones

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16. Database Connectivity

Microsoft ADO.NET is the .NET equivalent of the JDBC API and provides the programmer with consistent access to a variety of data sources. Most commonly, these will be SQL-based relational databases, but they can also be other tabular data sources, such as flat files and spreadsheets. ADO.NET consists of two major components:

  • Data Provider. The Data Provider includes the functionality required to manage a data source, including connection management, transaction support, and data retrieval and manipulation. The Data Provider also acts as a source of data to higher-level data manipulation components such as the DataSet.

  • DataSet. The DataSet is a disconnected, in-memory cache of data. The DataSet provides a simplified ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required