Programming Microsoft® ADO.NET 2.0: Advanced Topics

Master ADO.NET programming with in-depth coverage of advanced topics.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