Managing Cached Data and Schemas
At the start of this chapter, we mentioned that the ADO.NET classes support two ways of interacting with a database: direct access and cached access. We have already seen how we can issue commands to a database through the OLE DB and SQL Server .NET Data Providers. In this section, we illustrate the use of the DataSet class and its related classes.
The Anatomy of a DataSet
The DataSet class, in the System.Data namespace, enables you to programmatically create your own virtual database in memory. This virtual database can be fashioned complete with data, tables, table relationships, constraints, and so on. From a software design perspective, datasets are a great mechanism both for storage of data internal to an ...
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.
