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
- ISBN10 0735621411
- ISBN13 9780735621411
- Publish Date 2 November 2005
- Publish Status Out of Print
- Out of Print 22 May 2014
- Publish Country US
- Imprint Microsoft Press,U.S.
- Format Paperback
- Pages 528
- Language English