|
Programming ADO.NET 2.0 Applications: 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 PLUS - Get code samples on the Web
CONTENTS:
Overview
ADO.NET trace logging
Advanced connectivity to the data store
Disconnected data
Realational disconnected data
Windows data grid controlweb data grid control
sqlclr
Uunerstanding transactions
Retreiving meta data
Data caching
Security
LOBs, BLOBs & CLOBs
XML data
|
