Programming ADO.NET 2.0 Applications: Advanced Topics

Description

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

CONTENTS:

DedicationForewordAcknowledgmentsIntroductionChapter 1: Overview of ADO.NET Disconnected ClassesChapter 2: Overview of ADO.NET Connected ClassesChapter 3: ADO.NET Trace LoggingChapter 4: Advanced Connectivity to the Data StoreChapter 5: Working with Disconnected DataChapter 6: Working with Relational Disconnected DataChapter 7: Working with the Windows Data Grid ControlChapter 8: Working with the Web Data Grid ControlChapter 9: Working with the SQLCLRChapter 10: Understanding TransactionsChapter 11: Retrieving MetadataChapter 12: Data Caching for PerformanceChapter 13: Implementing SecurityChapter 14: Working with Large Objects (LOBs, BLOBs, and CLOBs)Chapter 15: Working with XML DataAbout the AuthorAdditional Resources for Visual Basic DevelopersAdditional Resources for C# DevelopersAdditional Resources for Web DevelopersAdditional Resources for Database Developers