2542: Advanced Data Access Development with Visual Studio 2005

This two-day 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. The workshop describes how to access data and how to implement database functionality by using Microsoft ADO.NET 2.0 and Microsoft SQL Server 2005.

The workshop also describes how to locate, edit, and transform XML by using XPath and Extensible Style sheet Language for Transformations (XSLT).

Doelgroep

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.

Voorkennis

Before attending this workshop, students must:

• Have attended or studied Workshop MS2541, 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.

Inhoud

Unit 1: Minimizing and Handling Database Operation ConflictsThis unit describes how to minimize data access conflicts, and how to handle these conflicts when they occur. It describes how to implement optimistic concurrency in the ADO.NET disconnected model, and how to implement optimistic concurrency by using the various isolation levels available in SQL Server 2005.

Lessons

• Why Do Data Conflicts Arise?
• Isolation Levels Available in SQL Server 2005
• Guidelines for Using SQL Server 2005 Isolation Levels

Lessons

• 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

Lessons

• ADO.NET Enhancements in the .NET Framework 2.0
• SQL Server Provider Statistics

Lessons

• 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

Lessons

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

Lessons

• What Is XSLT?
• The Process for Executing an XSLT Style Sheet
• What Are Extension Objects?