Description
A hands-on course for application developers who have taken the Visual Basic.NET Intensive Workshop (or equivalent), and/or ASP.NET Workshop.  Students will build windows and web applications using ADO.NET objects, including Connection, DataReader, DataAdapter, DataSet, and Command, to read and update database tables.

Audience
For application developers who will be building Windows and Web applications using ADO.NET objects, including Connection, DataReader, DataAdapter, DataSet, and Command, to read and update database tables.

Prerequisites
Assumes the student is familiar with some relational database (Access, Oracle, SQL Server, DB2, etc), and has the brief overview from the VB or ASP course.

Hardware and Software
Windows NT Server, 2000 or XP with Visual Studio.NET and IIS, for each student and the instructor, preferably with systems networked.

Format

• Presentation
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Understand the ADO.NET object model and its goals, and its comparison to classic ADO
• Use Providers to connect to all types of databases, including desktop (e.g. Access), client-server (Oracle, SQL Server, etc) and other (files, spreadsheets, etc)
• Use Toolbox tools and wizards to create simple read-only Windows and Web database applications
• Use code to define and manage connections and data adapters, and be familiar with their main properties and methods
• Create a DataSet, tables, relationships, constraints, and views
• Provide user-directed search capabilities in Windows and Web applications
• Handle data-related exceptions that occur
• Handle transactions, commit and rollback, locking and isolation issues
• Deploy database applications to windows desktops and servers, and web servers
  

Overview

• Comparison to ADO Classis
• ADO classes in the .NET framework
• Managed providers
• Disconnected Data Environment
• Use of XML To Transmit Data

Simple ADO.NET applications

• Using the Dataform wizard to create a query and update windows form
• Using Data-Bound controls, including Text, Listbox, Datagrid, and others

Reading Data Efficiently

• The Connection Object’s Properties and Methods.
• The Datareader’s Properties and Methods.
• Using Datareader’s in VB.NET
• Using Datareader’s in ASP.NET
  

Updating Data

• The Dataadapter's Purpose, Properties And Methods
• The Dataset's Purpose, Properties And Methods
• Using Tables, Relations, Constraints
• Filtering And Sorting A Table With A Dataview 
• Updating Single Rows
• Using The Command Object And Parameters To Perform All Kinds Of Updates
• Using Database Stored Procedures
  
  

Advanced Techniques

• Synchronizing Updates In The Database
• Handling Exceptions
• Transaction Handling, Commit And Rollback
• Locking And Isolation
  

Testing, Debugging and Distributing

• Special Testing And Debugging Considerations 
• The Common Language Runtime And Its Advantages 
• Side-By-Side Deployment With ADO Classic