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.
 
Upcoming classes
Number Class Date Location Length Cost Sign up
MS2541 Aug 19, 2013 - Aug 21, 2013 Springfield 3 days $1595.00 Register
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