Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

MS2541 - Core Data Access with Microsoft Visual Studio 2005

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com
This 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.
Click here for a printer-friendly version of this page.
 
This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.
Contact us for additional availability.


Prerequisites

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
 
Detailed Class Syllabus


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


  • 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


  • Performing Transactional Operations
  • What Is a Transaction?

  • The Process for Managing Local Transactions

  • Isolation Levels

  • Lab 3: Performing Transactional Operations


  • 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


  • 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


  • Performing XML Operations on Disconnected Data
  • XML Representations of DataSets

  • What Are DiffGrams?

  • Lab 6: Performing XML Operations on Disconnected Data


  • 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


  • 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
  •  
    Microsoft Partner Gold LearningPrometricEC-Council