• Table of Contents

  Page 9

• Foreword

  Page 17

• Introduction

  Page 21

• Chapter 1. Overview of ADO.NET Disconnected Classes

  Page 27

• Chapter 2. Overview of ADO.NET Connected Classes

  Page 65

• Chapter 3. ADO.NET Trace Logging

  Page 101

• Chapter 4. Advanced Connectivity to the Data Store

  Page 115

• Chapter 5. Working with Disconnected Data

  Page 141

• Chapter 6. Working with Relational Disconnected Data

  Page 173

• Chapter 7. Working with the Windows Data Grid Control

  Page 197

• Chapter 8. Working with the Web Data Grid Control

  Page 229

• Chapter 9. Working with the SQLCLR

  Page 267

• Chapter 10. Understanding Transactions

  Page 315

• Chapter 11. Retrieving Metadata

  Page 345

• Chapter 12. Data Caching for Performance

  Page 367

• Chapter 13. Implementing Security

  Page 385

• Chapter 14. Working with Large Objects (LOBs, BLOBs, and CLOBs)

  Page 427

• Chapter 15. Working with XML Data

  Page 439

• Index

  Page 501

Dive in for reference where you need it—and learn the intricacies of developing sleeker, more robust, security-enhanced applications in ADO.NET 2.0. Featuring code samples in Microsoft Visual C# and Visual Basic, this reference goes beyond the fundamentals to help professional developers solve sophisticated enterprise development problems.

Discover how to:

• Examine advanced connectivity options and best practices—including connection pooling, clustered connections, and asynchronous access

• Use tracing to diagnose application flow and performance issues

• Resolve concurrency conflicts and implement a data access layer

• Implement seamless application failover from one Microsoft SQL Server database to another

• Use managed code and the SQLCLR to create stored procedures, user-defined functions and types, aggregates, and triggers

• Write effective data-caching code to improve application performance

• Use the Systems.Transactions namespace to work with Microsoft SQL Server 2005

• Implement streaming techniques to “chunk” data

• Apply various methods to extract and modify XML data

PLUS—Get code samples on the Web