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