| Outline:
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 |