MOC-2389: Programming with Microsoft ADO.NET

Module 1: Data-Centric Applications and ADO.NET

- Design of Data-Centric Applications

- ADO.NET Architecture

- ADO.NET and XML

Module 2: Connecting to Data Sources

- Choosing a .NET Data Provider

- Defining a Connection

- Managing a Connection

- Handling Connection Exceptions

- Connection Pooling

Module 3: Performing Connected Database Operations

- Working in a Connected Environment

- Building Command Objects

- Executing Commands That Return a Single Value

- Executing Commands That Return Rows

- Executing Commands That Do Not Return Rows

- Using Transactions

Modulo 4: Building DataSets

- Working in a Disconnected Environment

- Building DataSets and DataTables

- Binding and Saving a DataSet

- Defining Data Relationships

- Modifying Data in a DataTable

- Sorting and Filtering

Module 5: Reading and Writing XML with ADO.NET

- Creating XSD Schemas

- Loading Schemas and Data into DataSets

- Writing XML from a DataSet

Module 6: Building DataSets from Existing Data Sources

- Configuring a DataAdapter to Retrieve Information

- Populating a DataSet Using a DataAdapter

- Configuring a DataAdapter to Update the Underlying Data Source

- Persisting Changes to a Data Source

- How to Handle Conflicts

Module 7: Building and Consuming a Web Service That Uses ADO.NET

- Build a Web service

- Consume a Web service in a client application

- Troubleshoot errors in an ADO.NET application