ADO NET in a Nutshell



•	Table of Contents
•	Index
•	Reviews
•	Examples
•	Reader Reviews
•	Errata

ADO.NET in a Nutshell
By Bill Hamilton, Matthew MacDonald

Publisher	: O'Reilly
Date Published	: April 2003
ISBN	: 0-596-00361-7
Pages	: 620

Preface

Audience

Contents of This Book

What's on the CD-ROM

Conventions Used in This Book

Comments and Questions

Acknowledgments

Part I: ADO.NET Tutorial

Chapter 1. Introduction

Section 1.1. ADO.NET Data Providers

Section 1.2. Connected and Disconnected Data

Chapter 2. .NET Data Providers

Section 2.1. Data Providers

Section 2.2. Selecting a Data Provider

Section 2.3. Creating a Custom Data Provider

Chapter 3. Connections

Section 3.1. Connection Object Overview

Section 3.2. The Connection String

Section 3.3. Opening and Closing Connections

Section 3.4. Connection Pooling

Chapter 4. Commands

Section 4.1. Command Object Overview

Section 4.2. Creating and Executing a Command

Section 4.3. Parameter Object Overview

Section 4.4. Parameterized Commands

Section 4.5. Commands with Stored Procedures

Section 4.6. Commands and Data Definition Language (DDL)

Chapter 5. DataReaders

Section 5.1. DataReader Object Overview

Section 5.2. Performing a Query with a DataReader

Section 5.3. Stored Procedures with the DataReader

Section 5.4. DataReaders and Schema Information

Chapter 6. DataSets

Section 6.1. Creating an Untyped DataSet

Section 6.2. Working with Tables in the DataSet

Section 6.3. Adding and Removing Relations

Section 6.4. Adding Custom Information

Section 6.5. Cloning the Schema

Section 6.6. Copying the DataSet

Section 6.7. Merging Two DataSets

Section 6.8. Removing All Data

Section 6.9. Resetting the DataSet

Section 6.10. Committing and Discarding Changes

Chapter 7. DataTables

Section 7.1. Creating a DataTable

Section 7.2. Working with Columns

Section 7.3. Constraints

Section 7.4. Primary Key

Section 7.5. Rows

Section 7.6. Loading Data

Section 7.7. Committing and Discarding Changes

Section 7.8. Cloning the Schema of the Table

Section 7.9. Copying the Table

Section 7.10. Selecting a Subset of Rows

Section 7.11. Performing Aggregate Calculations

Section 7.12. Removing All Data

Section 7.13. Resetting the Table

Section 7.14. Identifying Errors in the Table

Section 7.15. DataTable Events

Chapter 8. DataColumns

Section 8.1. Creating DataColumns

Section 8.2. Creating AutoIncrement Columns

Section 8.3. Creating Expression Columns

Section 8.4. Handling Null Values

Section 8.5. Mapping .NET Data Provider Types to .NET Framework Types

Chapter 9. DataRows

Section 9.1. Creating a DataRow

Section 9.2. Updating Rows

Section 9.3. Deleting Rows

Section 9.4. Using Row State Information

Section 9.5. Using Row Version Information

Section 9.6. Accepting or Rejecting Changes to Rows

Section 9.7. Navigating Parent and Child Rows

Section 9.8. Using Row Error Information

Chapter 10. Constraints

Section 10.1. Constraint Object Overview

Section 10.2. The UniqueConstraint

Section 10.3. The ForeignKeyConstraint

Chapter 11. DataRelations

Section 11.1. DataRelation Object Overview

Section 11.2. Navigating Relational Data

Chapter 12. DataViews and Data Binding

Section 12.1. The DataView and DataViewManager

Section 12.2. Sorting and Filtering

Section 12.3. Accessing Data Through a DataView

Section 12.4. Windows Data Binding

Section 12.5. ASP.NET Data Binding

Chapter 13. Strongly Typed DataSets

Section 13.1. Creating a Strongly Typed DataSet

Section 13.2. Adding a Row

Section 13.3. Editing a Row

Section 13.4. Finding a Row

Section 13.5. Null Data

Section 13.6. Navigating Hierarchical Data

Section 13.7. Annotations

Chapter 14. DataAdapters

Section 14.1. Creating DataAdapter Object

Section 14.2. Retrieving Data from the Data Source

Section 14.3. Retrieving Schema Information from the Data Source

Section 14.4. Updating the Data Source

Section 14.5. Mapping Tables and Columns

Section 14.6. AcceptChangesDuringFill

Section 14.7. ContinueUpdateOnError

Section 14.8. DataAdapter Events

Chapter 15. Updating the Data Source

Section 15.1. SqlCommandBuilder Class Overview

Section 15.2. Updating a Data Source Using Command Builder

Section 15.3. Updating a Data Source Using Custom Logic

Section 15.4. Refreshing Data After Updating

Section 15.5. Retrieving Updated Values from the Data Source

Section 15.6. Updating Data in Related Tables

Section 15.7. Handling Concurrency Issues

Section 15.8. Optimization

Chapter 16. Transactions

Section 16.1. Manual Transactions

Section 16.2. Isolation Levels

Section 16.3. Savepoints

Section 16.4. Nested Transactions

Section 16.5. Transactions Using a DataAdapter

Section 16.6. Automatic Transactions

Chapter 17. XML and the DataSet

Section 17.1. DataSet XML Methods

Section 17.2. Shaping DataSet XML

Section 17.3. Other .NET XML Classes

Section 17.4. XmlDataDocument Object Overview

Section 17.5. Using the Data Objects to Edit XML

Section 17.6. SQL Server 2000 XML

Part II: ADO.NET Core Classes

Chapter 18. The Connection Class

Section 18.1. Comments/Troubleshooting

Section 18.2. Properties Reference

Section 18.3. Methods Reference

Section 18.4. Events Reference

Chapter 19. The Command Class

Section 19.1. Comments/Troubleshooting

Section 19.2. Properties Reference

Section 19.3. Collections Reference

Section 19.4. Methods Reference

Chapter 20. The Parameter Class

Section 20.1. Comments/Troubleshooting

Section 20.2. Properties Reference

Chapter 21. The DataReader Class

Section 21.1. Comments/Troubleshooting

Section 21.2. Properties Reference

Section 21.3. Methods Reference

Chapter 22. The DataSet Class

Section 22.1. Comments/Troubleshooting

Section 22.2. Properties Reference

Section 22.3. Collections Reference

Section 22.4. Methods Reference

Section 22.5. Events Reference

Chapter 23. The DataTable Class

Section 23.1. Comments/Troubleshooting

Section 23.2. Properties Reference

Section 23.3. Collections Reference

Section 23.4. Methods Reference

Section 23.5. Events Reference

Chapter 24. The DataColumn Class

Section 24.1. Comments/Troubleshooting

Section 24.2. Properties Reference

Section 24.3. Collections Reference

Chapter 25. The DataRow Class

Section 25.1. Comments/Troubleshooting

Section 25.2. Properties Reference

Section 25.3. Collections Reference

Section 25.4. Methods Reference

Chapter 26. The Constraint Class

Section 26.1. Comments/Troubleshooting

Section 26.2. Properties Reference

Section 26.3. Collections Reference

Chapter 27. The DataRelation Class

Section 27.1. Comments/Troubleshooting

Section 27.2. Properties Reference

Section 27.3. Collections Reference

Chapter 28. The DataView Class

Section 28.1. Comments/Troubleshooting

Section 28.2. Properties Reference

Section 28.3. Methods Reference

Section 28.4. Events Reference

Chapter 29. The DataAdapter Class

Section 29.1. Comments/Troubleshooting

Section 29.2. Properties Reference

Section 29.3. Collections Reference

Section 29.4. Methods Reference

Section 29.5. Events Reference

Chapter 30. The CommandBuilder Class

Section 30.1. Comments/Troubleshooting

Section 30.2. Properties Reference

Section 30.3. Methods Reference

Chapter 31. The Transaction Class

Section 31.1. Comments/Troubleshooting

Section 31.2. Properties Reference

Section 31.3. Methods Reference

Part III: API Quick Reference

Chapter 32. How to Use This Quick Reference

Section 32.1. Finding a Quick-Reference Entry

Section 32.2. Reading a Quick-Reference Entry

Chapter 33. Converting from C# to VB Syntax

Section 33.1. General Considerations

Section 33.2. Classes

Section 33.3. Structures

Section 33.4. Interfaces

Section 33.5. Class, Structure, and Interface Members

Section 33.6. Delegates

Section 33.7. Enumerations

Chapter 34. The System.Data Namespace

DataColumnChangeEventArgs

DataColumnChangeEventHandler

DataColumnCollection

DataException

DataRelation

DataRelationCollection

DataRow

DataRowAction

DataRowChangeEventArgs

DataRowChangeEventHandler

DataSysDescriptionAttribute

DataViewSettingCollection

DBConcurrencyException

DbType

DeletedRowInaccessibleException

DuplicateNameException

EvaluateException

FillErrorEventArgs

FillErrorEventHandler

ForeignKeyConstraint

IColumnMapping

IColumnMappingCollection

IDataAdapter

IDataParameter

IDataParameterCollection

InRowChangingEventException

InternalDataCollectionBase

InvalidConstraintException

InvalidExpressionException

IsolationLevel

ITableMapping

ITableMappingCollection

MappingType

MergeFailedEventArgs

MergeFailedEventHandler

MissingMappingAction

MissingPrimaryKeyException

MissingSchemaAction

NoNullAllowedException

RowNotInTableException

StateChangeEventHandler

StatementType

StrongTypingException

SyntaxErrorException

TypedDataSetGenerator

TypedDataSetGeneratorException

UniqueConstraint

UpdateRowSource

UpdateStatus

VersionNotFoundException

XmlReadMode

XmlWriteMode

Chapter 35. The System.Data.Common Namespace

DataAdapter

DataColumnMapping

DataColumnMappingCollection

DataTableMapping

DataTableMappingCollection

DbDataAdapter

DBDataPermission

DBDataPermissionAttribute

Chapter 36. The System.Data.SqlClient Namespace

SqlClientPermission

SqlClientPermissionAttribute

SqlInfoMessageEventArgs

SqlInfoMessageEventHandler

SqlParameter

SqlParameterCollection

SqlRowUpdatedEventArgs

SqlRowUpdatedEventHandler

SqlRowUpdatingEventArgs

SqlRowUpdatingEventHandler

SqlTransaction

Chapter 37. The System.Data.OleDb Namespace

OleDbInfoMessageEventArgs

OleDbInfoMessageEventHandler

OleDbParameter

OleDbParameterCollection

OleDbPermission

OleDbPermissionAttribute

OleDbRowUpdatedEventArgs

OleDbRowUpdatedEventHandler

OleDbRowUpdatingEventArgs

OleDbRowUpdatingEventHandler

OleDbSchemaGuid

OleDbTransaction

OleDbType

Chapter 38. The System.Data.SqlTypes Namespace

SqlNullValueException

Appendix A. ADO.NET Providers

Section A.1. The SQL Server Provider

Section A.2. The OLE DB Provider

Section A.3. The ODBC .NET Provider

Section A.4. The Oracle .NET Provider

Section A.5. The ODP.NET Provider

Appendix B. ADO.NET XML Extensions

Section B.1. codegen Namespace

Section B.2. msdata Namespace

Section B.3. diffgr Namespace

Appendix C. Microsoft Data Engine (MSDE)

Section C.1. Installing MSDE

Section C.2. MSDE Essentials

Section C.3. Adding the Northwind Data

Section C.4. Migrating MSDE to SQL Server

Type, Method, Property, and Field Index