Data-Centric Applications and ADO.NET
o Design of Data-Centric Applications
o ADO.NET Architecture
o ADO.NET and XML
Connecting to Data Sources
o Choosing a .NET Data Provider
o Defining a Connection
o Managing a Connection
o Handling Connection Exceptions
o Connection Pooling
Performing Connected Database Operations
o Working in a Connected Environment
o Building Command Objects
o Executing Commands That Return a Single Value
o Executing Commands That Return Rows
o Executing Commands That Do Not Return Rows
o Using Transactions
Building DataSets
o Working in a Disconnected Environment
o Building DataSets and DataTables
o Binding and Saving a DataSet
o Defining Data Relationships
o Modifying Data in a DataTable
o Sorting and Filtering
Reading and Writing XML with ADO.NET
o Creating XSD Schemas
o Loading Schemas and Data into DataSets
o Writing XML from a DataSet
Building DataSets from Existing Data Sources
o Configuring a DataAdapter to Retrieve Information
o Populating a DataSet Using a DataAdapter
o Configuring a DataAdapter to Update the Underlying Data Source
o Persisting Changes to a Data Source
o How to Handle Conflicts
Building and Consuming a Web Service That Uses ADO.NET
o Building and Consuming a Web Service That Returns Data
