WORKSHOP CONTENTS
Unit 1: Connecting to Databases and Reading Data
· What Is ADO.NET?
· The Process for Connecting to a Database and Reading Data
· What Is Connection Pooling?
Lab : Connecting to Databases and Reading Data
· Connecting to a Database
· Saving a Connection String Securely in an Application Configuration File
· Retrieving Data from a Database
· Handling Connection Events and Exceptions
· Configuring and Using Connection Pooling (if time permits)
Unit 2: Querying and Updating Databases by Using Commands
· ADO.NET Commands
· The Process for Passing Parameters into Commands
Lab : Querying and Updating Databases by Using Commands
· Creating and Running Query Commands
· Creating and Running Parameterized Commands
· Creating and Running Update Commands
· Using Globalized Formats for Storing and Accessing Data (if time permits)
Unit 3: Performing Transactional Operations
· What Is a Transaction?
· The Process for Managing Local Transactions
· The Process for Managing Distributed Transactions
· Isolation Levels
Lab : Performing Transactional Operations
· Performing Data Updates within a Transaction
· Choosing an Appropriate Isolation Level for a Transaction
· Enlisting in a Distributed Transaction
· Managing Transactions in the Data Tier (if time permits)
Unit 4: Performing Disconnected Operations Programmatically
· What Is the ADO.NET Disconnected Model?
· The Process for Loading and Saving Data in a DataSet
· What Are DataViews?
Lab : Performing Disconnected Operations Programmatically
· Creating a DataSet Programmatically
· Populating and Saving a DataSet
· Adding, Modifying, and Deleting Data in a DataSet
· Merging DataSets
· Creating and Using DataViews (if time permits)
Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
· Comparing Untyped DataSets with Typed DataSets
· What Are Table Adapters?
· Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards
Lab : Performing Disconnected Operations by Using Visual Studio 2005 Wizards
· Creating a Typed DataSet by Using the DataSet Designer
· Loading, Displaying, and Saving Data in a Typed DataSet
· Adding Code to a Typed DataSet
· Creating a Typed DataSet by Using the Data Source Configuration Wizard
· Adding Queries to a Table Adapter (if time permits)
Unit 6: Performing XML Operations on Disconnected Data
· XML Representations of DataSets
· What Are DiffGrams?
Lab : Performing XML Operations on Disconnected Data
· Saving a DataSet as XML Data
· Loading a DataSet from XML
· Saving and Loading DataSet Schema Information
Unit 7: Reading and Writing XML Data
· The Process for Serially Reading XML Data
· The Process for Serially Writing XML Data
Lab : Reading and Writing XML Data
· Writing XML Data by Using XmlWriter
· Reading XML Data by Using XmlReader
Unit 8: Processing XML Data by Using DOM
· What Is DOM?
· What Are DOM Trees?
· Types of XML Nodes in a DOM Tree
Lab : Processing XML Data by Using DOM
· Reading XML Data by Using DOM
· Writing XML Data by Using DOM