Advanced Data Access with Microsoft Visual Studio 2005

Target Audience
This workshop provides students with the knowledge and skills needed to use advanced data access features and techniques in the Microsoft .NET Framework and Microsoft Visual Studio 2005. It 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.

Pre-Requisites
Before attending this course, students should have the following pre-requisites:Attended Course 2541, Core Data Access with Microsoft Visual Studio 2005, or possess equivalent knowledge and skills.Know how to use delegates.Be able to use database stored procedures, triggers, and aggregates.Be able to explain XPath concepts and basic syntax.Be able to explain XSLT style sheet concepts.

Purpose
After completing this workshop, students will be able to minimize and handle database operation conflicts; handle large objects; enhance database performance; create managed code objects for SQL Server 2005; query XML by using XPath; transform XML by using XSLT style sheets.

Course outline

1. Minimizing and Handling Database Operation Conflicts
2. Handling Large Objects
3. Enhancing Database Performance
4. Creating Managed Code Objects for SQL Server 2005
5. Querying XML by Using XPath
6. Transforming XML by Using XSLT Style Sheets

Module 1:Minimizing and Handling Database Operation Conflicts

• Why Do Data Conflicts Arise?
• Isolation Levels Available in SQL Server 2005
• Guidelines for Using SQL Server 2005 Isolation Levels
• Lab: Minimizing and Handling Database Operation Conflicts

• Explain why data conflicts arise.
  
• Describe the isolation levels that are available in SQL Server 2005.
  
• Describe the guidelines for using SQL Server 2005 isolation levels.
  
• Read committed data by using locks.
  
• Read committed data by using statement-level snapshots.
  
• Read committed data by using transaction-level snapshots.
  
• Handle data concurrency by using ADO.NET.
  

Module 2:Handling Large Objects

• What Are Binary Large Objects and Character Large Objects?
• The Process for Reading Large Objects from a Database
• The Process for Writing Large Objects to a Database
• Lab: Handling Large Objects

• Describe binary large objects and character large objects.
  
• Explain the process for reading large objects from a database.
  
• Explain the process for writing large objects to a database.
  
• Read large values from SQL Server.
  
• Write large values to SQL Server.
  
• Conserve resources when writing large values to SQL Server.
  

Module 3:Enhancing Database Performance

• ADO.NET Enhancements in the .NET Framework 2.0
• SQL Server Provider Statistics
• Lab: Enhancing Database Performance

• Describe the ADO.NET enhancements in Microsoft .NET Framework 2.0.
  
• Describe the support for run-time statistics in the .NET Framework Data Provider for SQL Server.
  
• Access multiple result sets concurrently.
  
• Perform asynchronous data access operations.
  
• Perform a batch update.
  
• Perform a bulk data copy.
  

Module 4:Creating Managed Code Objects for SQL Server 2005

• The Benefits of Creating Managed Code Objects
• Demonstration: The Process for Importing an Existing Assembly into SQL Server 2005
• Demonstration: The Process for Implementing Managed Code Objects in SQL Server 2005
• Lab: Creating Managed Code Objects for SQL Server 2005

• Describe the benefits of creating managed code objects for SQL Server 2005.
  
• Explain the process for importing an existing assembly into SQL Server 2005.
  
• Explain the process for implementing managed code objects in SQL Server 2005.
  
• Create managed stored procedures and triggers.
  
• Create managed user-defined functions.
  
• Create a managed aggregate.
  
• Create a managed user-defined type.
  

Module 5:Querying XML by Using XPath

• The XPath Data Model
• The Process for Selecting and Editing XML Data by Using XPathNavigator
• The Process for Evaluating XPath Expressions by Using XPathNavigator
• Lab: Querying XML by Using XPath

• Describe the XPath data model.
  
• Explain the process for selecting and editing XML data by using XPathNavigator.
  
• Explain the process for evaluating XPath expressions by using XPathNavigator.
  
• Select XML data by using XPathNavigator.
  
• Evaluate XPath expressions by using XPathNavigator.
  
• Create and use compiled XPath expressions.
  
• Edit XML data by using XPathNavigator.
  

Module 6:Transforming XML by Using XSLT Style Sheets

• What Is XSLT?
• The Process for Executing an XSLT Style Sheet
• What Are Extension Objects?
• Lab: Transforming XML by Using XSLT Style Sheets

• Describe the purpose of XSLT.
  
• Explain the process for executing an XSLT style sheet.
  
• Describe the purpose of extension objects.
  
• Transform an XML document by using an XSLT style sheet.
  
• Resolve external resources during XSLT processing.
  
• Pass parameters into an XSLT style sheet.
  
• Create and use extension objects.