Programming Microsoft Ado .NET 2.0 Applications: Advanced Topics

Dedication;
Foreword;
Acknowledgments;
Introduction;
Who This Book Is For;
How This Book Is Organized;
System Requirements;
Prerelease Software;
Technology Updates;
Code Samples;
Support for This Book;
Chapter 1: Overview of ADO.NET Disconnected Classes;
1.1 Getting Started with the DataTable Object;
1.2 Using a DataSet Object to Work with Lots of Data;
1.3 Looping Through Data with the DataTableReader;
1.4 Summary;
Chapter 2: Overview of ADO.NET Connected Classes;
2.1 Using Providers to Move Data;
2.2 Summary;
Chapter 3: ADO.NET Trace Logging;
3.1 Setting Up Tracing;
3.2 Summary;
Chapter 4: Advanced Connectivity to the Data Store;
4.1 Building Accurate Connection Strings;
4.2 Connection Pooling;
4.3 Asynchronous Data Access;
4.4 Working with SQL Server Provider Statistics;
4.5 Summary;
Chapter 5: Working with Disconnected Data;
5.1 Understanding Concurrency Issues;
5.2 Designing for Disconnected Data;
5.3 Who’s Afraid of the Big, Bad GUID?;
5.4 Building a Conflict Resolution Screen;
5.5 Summary;
Chapter 6: Working with Relational Disconnected Data;
6.1 Navigating Relationships;
6.2 Creating Constraints;
6.3 Updating Data: The Beginning of the Data Access Layer;
6.4 Summary;
Chapter 7: Working with the Windows Data Grid Control;
7.1 Understanding the DataGridView Control;
7.2 Summary;
Chapter 8: Working with the Web Data Grid Control;
8.1 Understanding the GridView Control;
8.2 GridView Setup;
8.3 Summary;
Chapter 9: Working with the SQLCLR;
9.1 Does the SQLCLR Replace T-SQL?;
9.2 Creating a Stored Procedure Without Visual Studio;
9.3 Creating a Stored Procedure by Using Visual Studio;
9.4 Passing Rowset Data;
9.5 Creating User-Defined Functions;
9.6 Working with User-Defined Aggregates;
9.7 Working with Triggers;
9.8 Working with User-Defined Types;
9.9 Accessing SQLCLR Features from the Client;
9.10 Summary;
Chapter 10: Understanding Transactions;
10.1 What Is a Transaction?;
10.2 Creating a Transaction;
10.3 Setting the Transaction Isolation Level;
10.4 Introducing the System.Transactions Namespace;
10.5 Best Practices;
10.6 Summary;
Chapter 11: Retrieving Metadata;
11.1 Getting Started;
11.2 Retrieving the Metadata Collections;
11.3 Summary;
Chapter 12: Data Caching for Performance;
12.1 Using the SqlDependency Class;
12.2 ASP.NET SQL Cache Invalidation;
12.3 Summary;
Chapter 13: Implementing Security;
13.1 Application Security Overview;
13.2 SQL Server Security;
13.3 ADO.NET Security;
13.4 Summary;
Chapter 14: Working with Large Objects (LOBs, BLOBs, and CLOBs);
14.1 What Are LOBs, BLOBs, and CLOBs?;
14.2 Summary;
Chapter 15: Working with XML Data;
15.1 Introducing XPath and XQuery;
15.2 Why Store XML Data in SQL Server 2005?;
15.3 The xml Data Type;
15.4 Getting Started with the xml Data Type;
15.5 Using XML with ADO.NET;
15.6 Summary;
About the Author;
Additional Resources for Visual Basic Developers;
Additional Resources for C# Developers;
Additional Resources for Web Developers;
Additional Resources for Database Developers;