Course 6681: Working with Data by using Microsoft ADO.NET 3.5 Applications.

Introduction This 2-hour online course provides you with the knowledge and skills to work with data by using ADO.NET 3.5 applications.

Topics covered in the course include:

• Method to work with data in a connected scenario
• Management of special data types by using ADO.NET

This course helps you prepare for exam 70-561 TS: Microsoft .NET Framework 3.5 - ADO.NET.

Student Prerequisites

• Three years of experience in developing Web applications, Windows-based applications, or distributed applications by using Microsoft .NET Framework 1.1 or 2.0
• Knowledge of programming in C# or Microsoft Visual Basic .NET (VB.NET)
• At least one year of experience in using Microsoft SQL Server and other relational database management systems such as Oracle, DB2, and MySQL
• Knowledge of Web services and XML
• Knowledge of stored procedures and data-bound controls

Objectives At the end of the course, students will be able to:

• Work with data in a connected scenario.
• Manage special data types by using ADO.NET.

Modules & Lessons Course Overview Module Overview Course Information Course Information Working with Data by Using ADO.NET 3.5 Applications Module Overview Working with Data in a Connected Scenario Working with Data in a Connected Scenario The DataReader Object How To Retrieve Data by Using DataReader Common Scenarios for Using DataReader Asynchronous Programming by Using DataReader Reviewing Data in a Connected Scenario Self Test Special Data Types in ADO.NET 3.5 Special Data Types in ADO.NET 3.5 Other Data Types in ADO.NET 3.5 Spatial Data Type Table-Valued Parameters Reviewing Special Data Types in ADO.NET Self Test Working with SQLCLR UDTs in ADO.NET 3.5 Working with SQLCLR UDTs in ADO.NET 3.5 SQLCLR UDTs in ADO.NET 3.5 Using SQLCLR UDTs Self Test Lab: Working with Data by Using ADO.NET 3.5 Applications Lab: Working with Data by Using ADO.NET 3.5 Applications Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled