Developing ADO.Net Applications Using SQL Server 2000 Training Class

Lesson 1: Overview of Data-centric Applications

Evolution of Data-centric Applications
.NET Architecture and Services Overview
ADO.NET
Working with BizTalk Server 2000

Lesson 2: ADO.Net Architecture

Using the Data-Related Namespaces
ADO.NET Object Model
Choosing Continuously Connected or Intermittently Connected Application Environment

Lesson 3: Connecting to SQL Server and Other Data Sources

Connecting to Data Sources
Managed Providers and Performance
Setting the Connection String
Creating a Custom Connection Class by Using Inheritance
Managing the Connection

Lesson 4: Accessing Data in a Connected Environment

Building SQL and OLE DB Command Objects
Running SQL and OLE DB Command Objects
Using the DataReader Object

Lesson 5: Modifying and Manipulating Data in a Connected Environment

Executing a Command Object that Encapsulates SQL
Executing a Command Object that Calls a Stored Procedure
Best Practices for Writing SQL Statements and Stored Procedures
Caching of Stored Procedures and Using Temporary Stored Procedures
Handling Exceptions
Controlling SQL Server Locking

Lesson 6: Building and Manipulating Schemas for a Local Data Cache

Defining Relationships (and an associated ForeignKeyConstraint)
Append the DataTable to a DataSet
Loading and Persisting a Local Cache Schema
Using ADO.NET to Persist Data as XML
Generating Schema from XML Documents

Lesson 7: Accessing Data in a Disconnected Environment

Configuring a DataAdapter to Retrieve Information
Creating a DataSet and Schema Automatically
Populating a DataSet Using a DataAdapter
Executing an XLANG Schedule Drawing

Lesson 8: Modifying and Manipulating Data in a Disconnected Environment

Configuring a DataAdapter to Modify Information
Modifying Data in a DataSet
Persisting Data Changes to a Server

Lesson 9: Managing Transactions

Using SQL Server Transactions
ADO.NET Connection and Transaction Objects
Enlisting in Distributed Transactions
Managing Queues

Lesson 10: Building a Distributed Application that Accesses Data

Why Build Web Services, Web Applications and Windows Applications?
Building a Web Service
Building a Web Application that Accesses Data
Building a Windows Application that Accesses Data