Programming ADO.NET 2.0 Applications: Advanced Topics

by Glenn Johnson (Author)

• Used

  Paperback
  2005

  $29.76

  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