Search Courses
Dates for this class:
No dates are available for this class.

Course Details    [choose new course]     [printable version]
Core Data Access Development with Visual Studio 2005 (MOC2541)
Course Number: MOC2541
Category: Programming & Dev Tools
Duration: 3.00 days
Description

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.

Target Audience

This workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development.

Prerequisites

Before attending this course, students must have:

  • Be able to manage a solution environment using the Visual Studio 2005 integrated development environment IDE and tools
  • Understand the .NET Framework 2.0 and the Common Language Runtime
  • Be able to program an application using a .NET Framework 2.0 compliant language
  • Know how to make assemblies available to other applications
  • Have a good understanding of basic relational database concepts
  • Be able to use basic SQL commands
  • Have a good understanding of XML including XML declaration, elements, attributes, and namespaces
  • Be able to explain XML schema concepts
Objectives

After completing 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.
Outline
  • 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 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)
  • Unit 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)
  • Unit 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)
  • 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 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)
  • 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 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)
  • Unit 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
  • Unit 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
  • Unit 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