ADO.NET and System.Xml v. 2.0--The Beta Version, 2/e

Table of Contents:

Figures xv

Tables xxi

Forewords xxv

Acknowledgments xxxi

Chapter 1: New Concepts in Data Access 1

The Evolution of Data Management in .NET 2

About the .NET Version 2.0 Beta Release 5

New Concepts in Version 2.0 8

A Summary of New Features in ADO.NET and System.Xml 9

New Data Source Controls and Data Binding Features in ASP.NET 35

Summary 38

Chapter 2: ADO.NET Data Management Enhancements 39

Expanded and Improved Data Access Features in ADO.NET 40

Asynchronous Command Execution 45

ADO.NET Promotable Transactions 67

ADO.NET Batched Updates 74

Bulk Data Copying in ADO.NET 81

Summary 101

Chapter 3: Provider Factories, Schema Discovery, and Security 103

Provider Factories 104

The DbConnectionStringBuilder Class 109

The Schema Discovery API 111

Security and Permissions 118

Retrieving Connection Statistics 119

ADO.NET 2.0 Performance Counters 120

Summary 122

Chapter 4: The DataSet and DataTable Classes 123

Scenarios for the DataSet and DataTable Classes 124

DataSet Performance Improvements 130

New Features of the DataSet 134

The Stand-Alone DataTable Class 151

Visual Studio 2005 DataSet Designer 163

Summary 168

Chapter 5: ADO.NET and SQL Server 2005 171

Multiple Active Results Sets 172

SQL Server Query Notifications 180

SQL Server User-Defined Types 195

Summary 207

Chapter 6: SQL Server 2005 CLR Hosting 209

Scenarios for the SQL Server CLR 210

The In-Process Data Provider in the Beta 2 Release 211

Examples of the In-Process Data Provider 213

Using the ADO.NET Classes in the SQL Server CLR 231

Summary 235

Chapter 7: XML in SQL Server 2005 237

SQL Server as an XML Database 238

Accessing the xml Data Type from ADO.NET 257

Using the XML Classes in the SQL Server CLR 276

Summary 283

Chapter 8: XML in the .NET Framework 285

The Growing Importance of XML 286

Why You Need XML 295

System.Xml Version 1.x 296

XML as a Universal Data Access Technology 300

What’s New in System.Xml Version 2.0? 303

XML Support in Visual Studio 2005 306

A Brief Overview of XQuery 312

Summary 321

Chapter 9: Reading and Writing XML 323

Scenarios for the XmlReader and XmlWriter 324

The XmlReader Class in Version 2.0 of System.Xml 324

Using the XmlReaderSettings-Created XmlReader 337

Reading Typed XML 344

Methods for Usability and Streaming Content 358

An Overview of the XmlWriter Class 367

The XmlWriter Class in Version 2.0 of System.Xml 369

Combining the XmlReader and XmlWriter Classes 383

Using the XmlResolver to Access Data Sources 389

Security and XML 398

Inferring an XML Schema from an XML Document 404

Summary 408

Chapter 10: XML Serialization Enhancements 411

Pre-generation of Serialization Assemblies 412

Full Support for IXmlSerializable 415

Schema Importer Extensions 418

Summary 421

Chapter 11: XML Document Stores 423

Scenarios for Working with XML Stores 424

Using the XmlDocument Class 426

Limitations of the XML DOM 428

Design Guidelines for Exposing XML from Your Classes 430

The XPathNavigator with the Cursor-Editing Model 431

Using the XPathNavigator for Editing 436

Working with Typed XML Using the XPathNavigator 445

XML Schema Validation and the XmlDocument Class 451

Data Transfer Methods on the XPathNavigator 461

XPath 1.0 Querying 463

Summary 468

Chapter 12: Transforming XML Documents 471

Scenarios for XSLT 472

The XslCompiledTransform Class 473

Script, Input Parameters, and Extension Objects in XSLT 484

Security and XSLT 490

XSLT Performance Comparison 494

Summary 495

Index 497