Programming Microsoft ADO.NET 2.0 Applications

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