2389b Programming With Microsoft Ado.Net en Tijuana

Lesson 1: Data-Centric Applications and ADO.NET

• Design of Data-Centric Applications

• ADO.NET Architecture

• ADO.NET and XML

Lesson 2: Connecting to Data Sources

• Choosing a .NET Data Provider

• Defining a Connection

• Managing a Connection

• Handling Coonection Exceptions

• Connection Pooling

Lesson 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

Lesson 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

Lesson 5: Reading and Writing XML with ADO.NET

• Creating XSD Schemas

• Loading Schemas and Data into DataSets

• Writing XML from a DataSet

Lesson 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

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

• Building and Consuming a Web Service That Returns Data