Programming Microsoft ADO.NET 2.0 applications

by Glenn Johnson

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 fun