Programming Microsoft ADO.NET 2.0 applications

Get detailed guidance on how to master the advanced topics and capabilities for developing sleeker, more robust, and security-enhanced applications in ADO.NET 2.0, a key technology in Microsoft Visual Studio® 2005. 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 accessUse 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 anotherUse 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 performanceUse the Systems.Transactions namespace to work with Microsoft SQL Server 2005Implement streaming techniques to "chunk" dataApply various methods to extract and modify XML dataPLUS—Get code samples on the Web