New Horizons Computer Learning Center
410-597-9722

2541: Core Data Access with Microsoft Visual Studio 2005

Course Length: 3 Days

Overview:
This three-day instructor-led workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET. The workshop also describes how to create, read, and write XML data.

Prerequisites:
Experience with XML and .NET

Course Objectives:
Upon successful completion of this course, students will be able to:

• 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 Content

Lesson 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 1: Connecting to Databases and Reading Data
• Exercise 1. Connecting to a Database
• Exercise 2. Saving a Connection String Securely in an Application Configuration File
• Exercise 3. Retrieving Data from a Database
• Exercise 4. Handling Connection Events and Exceptions
• Exercise 5. Configuring and Using Connection Pooling (if time permits)

Lesson 2: Querying and Updating Databases by Using Commands

• ADO.NET Commands
• The Process for Passing Parameters into Commands
• Lab 2: Querying and Updating Databases by Using Commands
• Exercise 1. Creating and Running Query Commands
• Exercise 2. Creating and Running Parameterized Commands
• Exercise 3. Creating and Running Update Commands
• Exercise 4. Using Globalized Formats for Storing and Accessing Data (if time permits)

Lesson 3: Performing Transactional Operations

• What Is a Transaction?
• The Process for Managing Local Transactions
• The Process for Managing Distributed Transactions
• Isolation Levels
• Lab 3: Performing Transactional Operations
• Exercise 1. Performing Data Updates within a Transaction
• Exercise 2. Choosing an Appropriate Isolation Level for a Transaction
• Exercise 3. Enlisting in a Distributed Transaction
• Exercise 4. Managing Transactions in the Data Tier (if time permits)

Lesson 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 4: Performing Disconnected Operations Programmatically
• Exercise 1. Creating a DataSet Programmatically
• Exercise 2. Populating and Saving a DataSet
• Exercise 3. Adding, Modifying, and Deleting Data in a DataSet
• Exercise 4. Merging DataSets
• Exercise 5. Creating and Using DataViews (if time permits)

Lesson 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 5: Performing Disconnected Operations by Using Visual Studio 2005 Wizards
• Exercise 1. Creating a Typed DataSet by Using the DataSet Designer
• Exercise 2. Loading, Displaying, and Saving Data in a Typed DataSet
• Exercise 3. Adding Code to a Typed DataSet
• Exercise 4. Creating a Typed DataSet by Using the Data Source Configuration Wizard
• Exercise 5. Adding Queries to a Table Adapter (if time permits)

Lesson 6: Performing XML Operations on Disconnected Data

• XML Representations of DataSets
• What Are DiffGrams?
• Lab 6: Performing XML Operations on Disconnected Data
• Exercise 1. Saving a DataSet as XML Data
• Exercise 2. Loading a DataSet from XML
• Exercise 3. Saving and Loading DataSet Schema Information

Lesson 7: Reading and Writing XML Data

• The Process for Serially Reading XML Data
• The Process for Serially Writing XML Data
• Lab 7: Reading and Writing XML Data
• Exercise 1. Writing XML Data by Using XmlWriter
• Exercise 2. Reading XML Data by Using XmlReader

Lesson 8: Processing XML Data by Using DOM

• What Is DOM?
• What Are DOM Trees?
• Types of XML Nodes in a DOM Tree
• Lab 8: Processing XML Data by Using DOM
• Exercise 1. Reading XML Data by Using DOM
• Exercise 2. Writing XML Data by Using DOM

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com