O'Reilly logo

Essential ADO.NET by Bob Beauchemin

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

4.1. DataSets

In this chapter, we begin our journey into the disconnected data access model by looking at the DataSet class. As described in Chapter 2, DataSet is a specialized collection class. It is the top-level object in the disconnected ADO.NET data access model. The DataSet class is built around relational data concepts, the CLR type system, and .NET collections. It can exchange data with both XML providers and data providers, or it can be manipulated directly in program code.

The DataSet class is meant to provide a cache of data outside the database that can be used in read-only mode, thereby preventing unnecessary round-trips to the database to fetch lookup tables—that is, tables of relatively constant information, such as interest rates, ...

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