Call on 1300 794 006

Schedules

To view the course schedule for your location, click on one of the locations below. In case
your location of interest is not listed below, please use the 'Other' option for your state:

	Sydney
	Newcastle
	Wollongong
	Wagga Wagga
	Other

	Melbourne
	Geelong
	Ballarat
	Bendigo
	Other

	Brisbane
	Gold Coast
	Sunshine Coast
	Toowoomba
	Townsville
	Other

Perth

	Canberra
	Other

	Adelaide
	Other

	Hobart
	Other

	Darwin
	Other

Home > Microsoft Technical > Visual Studio > Visual Studio 2005 (.NET 2.x) > ADO.NET (VB.NET or C#)

2542 - Advanced Data Access with Microsoft Visual Studio 2005 (C#)

Thanks for your interest!

There are currently no dates scheduled for this course.

Please feel free to register your interest and we'll be sure to let you know once a date is available.

REGISTRATION OF INTEREST

Overview:

This two-day instructor-led 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).

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.

Pre-requisites:

Before attending this course, students must have:

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

At Course Completion:

After completing this course, 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.

Outline:

Expand All

Session 1: Unit 1: Minimizing and Handling Database Operation Conflicts

This 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

Lab : Minimizing and Handling Database Operation Conflicts

Exercise 1. Reading Committed Data by Using Locks
Exercise 2. Reading Committed Data by Using Statement-Level Snapshots
Exercise 3. Reading Committed Data by Using Transaction-Level Snapshots
Exercise 4. Handling Data Concurrency by Using ADO.NET

After completing this unit, students will be able to:

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.

Session 2: Unit 2: Handling Large Objects

This unit describes how to read and write large values efficiently to a SQL Server database. It describes how to read large binary values and large text values by using SequentialAccess for a SqlDataReader. It also describes how to write large binary values and large text values, and how to conserve resources when writing large values.

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

Lab : Handling Large Objects

Exercise 1. Reading Large Values from SQL Server
Exercise 2. Writing Large Values to SQL Server
Exercise 3. Conserving Resources When Writing Large Values to SQL Server

After completing this unit, students will be able to:

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.

Session 3: Unit 3: Enhancing Database Performance

Session 4: Unit 4: Creating Managed Code Objects for SQL Server 2005

This unit describes how to create database objects for SQL Server 2005 in a .NET Framework programming language. It describes how to create stored procedures, triggers, user-defined functions, aggregates, and user-defined types in managed code. Additionally, it describes how to deploy an assembly that contains managed objects into SQL Server 2005, and how to declare database objects to reference the managed objects.

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

Lab : Creating Managed Code Objects for SQL Server 2005

Exercise 1. Creating Managed Stored Procedures and Triggers
Exercise 2. Creating Managed User-Defined Functions
Exercise 3. Creating a Managed Aggregate
Exercise 4. Creating a Managed User-Defined Type
Exercise 5. Importing Existing Assemblies into SQL Server 2005 (if time permits)

After completing this unit, students will be able to:

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.

Session 5: Unit 5: Querying XML by Using XPath

This unit describes how to use XPath in a .NET Framework application. It describes how to create an XPathNavigator object on an XML document, and how to locate content and evaluate expressions by using the XPathNavigator object. Additionally, it describes how to edit XML data by using the XPathNavigator object.

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

Lab : Querying XML by Using XPath

Exercise 1. Selecting XML Data by Using XPathNavigator
Exercise 2. Evaluating XPath Expressions by Using XPath Navigator
Exercise 3. Creating and Using Compiled XPath Expressions
Exercise 4. Editing XML Data by Using XPathNavigator

After completing this unit, students will be able to:

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.

Session 6: Transforming XML by Using XSLT Style Sheets

This unit describes how to transform XML documents in a .NET Framework application. It introduces how to load an XSLT style sheet in an application, and how to execute the style sheet to transform an XML document. The unit also describes how to pass parameters into a style sheet, and how to create and use extension objects.

Lessons