What you'll learn?

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

Description

This course 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.

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.

Topics :

Connecting to Databases and Reading Data

o  What Is ADO.NET?

o  The Process for Connecting to a Database and Reading Data

o  What Is Connection Pooling?

Querying and Updating Databases by Using Commands

o  ADO.NET Commands

o  The Process for Passing Parameters into Commands

Performing Transactional Operations

o  What Is a Transaction?

o  The Process for Managing Local Transactions

o  The Process for Managing Distributed Transactions

o  Isolation Levels

Performing Disconnected Operations Programmatically

o  What Is the ADO.NET Disconnected Model?

o  The Process for Loading and Saving Data in a DataSet

o  What Are DataViews?

Performing Disconnected Operations by Using Visual Studio 2005 Wizards

o  Comparing Untyped DataSets with Typed DataSets

o  What Are Table Adapters?

o  Demonstration: Creating a Typed DataSet by Using Visual Studio 2005 Wizards

Performing XML Operations on Disconnected Data

o  XML Representations of DataSets

o  What Are DiffGrams?

Reading and Writing XML Data

o  The Process for Serially Reading XML Data

o  The Process for Serially Writing XML Data

Processing XML Data by Using DOM

o  What Is DOM?

o  What Are DOM Trees?

o  Types of XML Nodes in a DOM Tree

Prerequisities :

Recommended Knowledge :

Before attending this workshop, students must: 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.

Recommended Course(s) :

Category :

  • Programming

Training Materials :

Microsoft Official Courseware (MOC)

Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.

Credential :

•Microsoft Certified Technology Specialist (MCTS): .NET Framework 2.0 Windows Applications •Microsoft Certified Technology Specialist (MCTS): .NET Framework 2.0 Web Applications •MCPD: Designing and Developing Windows Applications by Using the Microsoft .NET Framework •MCPD: Designing and Developing Web-Based Applications by Using the Microsoft .NET Framework