ADO.NET in a Nutshell

Contents of This Book

This book consists of a tutorial section that explains ADO.NET concepts, a class library references that describes every ADO.NET type, and several appendixes with supplementary information.

The best place to begin your exploration of ADO.NET is with the foundation chapters in Part I. Here’s a brief description of those chapters:

Chapter 1

Introduces the basic ADO.NET objects and their roles.

Chapter 2

Describes the classes that make up an ADO.NET data provider and the providers available with the .NET framework.

Chapter 3

Describes how to create a connection to a data source using ADO.NET and handle connection pooling.

Chapter 4

Describes the first level of ADO.NET: connection-based programming to perform live record updates, inserts, and deletions. Also shows how to interact with stored procedures and create parameterized commands.

Chapter 5

Explains how to retrieve the results of a query from a data source using a read-only, forward-only cursor. Also briefly demonstrates how you can write provider-agnostic ADO.NET code

Chapter 6

Introduces the heart of ADO.NET’s disconnected data features: the DataSet.

Chapter 7

Introduces the DataTable object that stores one or more rowsets in a DataSet.

Chapter 8

Explains the DataColumn object, which together with Constraint objects defines the schema for a DataTable.

Chapter 9

Explains the DataRow object, which contains an individual row of data in a DataTable.

Chapter 10

Describes Constraint objects, which enforce unique and foreign key constraints of data.

Chapter 11

Describes the DataRelation, which helps you navigate parent-child relationships and maintain referential integrity within the DataSet.

Chapter 12

Describes the DataView object, which represents a custom view of the data within a DataTable. The chapter discusses using the DataView to sort, filter, and edit data and to perform data binding in both Web and Windows Forms.

Chapter 13

Describes strongly typed DataSet classes, how to generate and use them, and considerations about their use.

Chapter 14

Describes how the DataAdapter class bridges the disconnected classes in ADO.NET with the underlying data source. The chapter explains how to retrieve data from the data source, place that data into a DataSet, and subsequently update modifications to the DataSet back to the underlying data source.

Chapter 15

Describes how to commit updates made in a DataSet to the original data source.

Chapter 16

Describes how to start and manage client-initiated transactions, and compares them with stored procedure transactions and distributed COM+ transactions.

Chapter 17

Explains how ADO.NET works with XML. You’ll learn what you can and can’t control with ADO.NET’s XML serialization, how DiffGrams store versioning information, and how web services encode the DataSet for transmission. Also introduces the XML features built into SQL Server 2000.

Part II, documents the core ADO.NET classes. A separate chapter is provided for each class, with an essential description of its properties, methods, and events.

Part III, provides a high-level reference of the ADO.NET namespaces. When you design or code an application, you’ll often find it useful to refer to this condensed class information.

Namespaces described in the reference include:

System.Data

System.Data.Common

System.Data.OleDb

System.Data.SqlClient

System.Data.SqlTypes

Part IV, encompasses the following:

Appendix A

Includes provider tables that show the key types for each provider, the data type mappings, and other miscellaneous details. Also describes some providers that aren’t included with .NET.

Appendix B

Explains the custom XML namespaces used when serializing a DataSet with versioning information or creating a typed DataSet schema.

Appendix C

Briefly describes MSDE, the freely distributable scaled-down version of SQL Server that can be used for desktop applications.

Glossary

Contains an alphabetic listing of the types and members found in Part III. You can use it to determine the namespace to which a particular type or member belongs.