  
                     
|
| |
 |
UNDERSTANDING ADO .NET - LEVEL ONE
| Course Description |
|
In this course, you will learn how to retrieve and manipulate data using Microsoft's new ADO.NET library. Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how to search, sort, and filter data using Select, Find, and DataViews.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
| Familiarity with database development and design.
|
• Introduction to ADO.NET
ADO.NET Code Created by Visual Studio
The ADO.NET Object Model
• Connecting to Data Sources
Connection Objects
Opening Connections
Connection Pooling
Retrieving Schema Information
Saving Connection Strings
• Retrieving Data
Introducing Command Classes
Working with DataReaders
Digging Deeper into Commands and
DataReaders
• Caching Data in DataSets
Introduction to DataSets
Populating a DataTable
Filling DataSets Using a DataAdapter
Retrieving Schema Information
DataSets and XML
• Applying Constraints
Using Constraints
Foreign Key Constraints
Other Constraints
|
• DataRelations
Creating DataRelations
Navigation Pathways
Expressions and Relations
Specifying XML Nesting
Revisiting the DataForm Wizard
• Updating Data
Creating Commands with CommandBuilders
Creating Commands
Using Stored Procedures
Revisiting the Wizard Code
• Using Strongly Typed DataSets
Using Loosely Typed DataSets
Creating a Strongly Typed DataSet
Using Strongly Typed DataSets
Issues with Strongly Typed DataSets
Revisiting the Data Form Wizard
• Handling Exceptions and Data Errors
Using Structured Exception Handling
Handling Provider Errors
Handling Concurrency Conflicts
Using Transactions
• Searching, Sorting, and Filtering
The Sample Project
Working with DataTables
Working with DataViews
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
