What You'll Learn

• Connect to databases and read data
• Query and update databases by using commands
• Perform transactional operations
• Perform disconnected operations programmatically
• Perform disconnected operations by using Visual Studio 2005 wizards
• Perform XML operations on disconnected data
• Read and write XML data
• Process XML data by using the Document Object Model DOM

Course Outline

1. Connecting to Databases and Reading Data

• ADO.NET
• Connecting to a Database and Reading Data
• Connection Pooling

2. Querying and Updating Databases by Using Commands

• ADO.NET Commands
• Passing Parameters into Commands

3. Performing Transactional Operations

• What a Transaction Is
• Managing Local Transactions
• Managing Distributed Transactions
• Isolation Levels

4. Performing Disconnected Operations Programmatically

• The ADO.NET Disconnected Model
• Loading and Saving Data in a DataSet
• DataViews

5. Performing Disconnected Operations by Using Visual Studio 2005 Wizards

• Comparing Untyped DataSets with Typed DataSets
• Table Adapters
• Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards

6. Performing XML Operations on Disconnected Data

• XML Representations of DataSets
• DiffGrams

7. Reading and Writing XML Data

• Serially Reading XML Data
• Serially Writing XML Data

8. Processing XML Data by Using DOM

• What DOM Is
• DOM Trees
• Types of XML Nodes in a DOM Tree

Labs

Lab 1: 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

Lab 2: 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

Lab 3: 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

Lab 4: 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

Lab 5: 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

Lab 6: Performing XML Operations on Disconnected Data

• Saving a DataSet as XML Data
• Loading a DataSet from XML
• Saving and Loading DataSet Schema Information

Lab 7: Reading and Writing XML Data

• Writing XML Data by Using XmlWriter
• Reading XML Data by Using XmlReader

Lab 8: Processing XML Data by Using DOM

• Reading XML Data by Using DOM
• Writing XML Data by Using DOM

Virtual Classroom e-Learning Classroom Dates

Date	Times
Oct 4 - 6, 2010	11:30 AM - 7:30 PM ET	Register

Don’t see the location or date you need? No problem – just use our Request a date & location service.