|
Provided by: Affinity IT Training, LLC Understanding ADO NET |
 |
Training
Provided by Affinity IT Training, LLC
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.
Audience:Developers who will be integrating Database access into .NET Applications and Database Administrators who will be supporting those Applications.
|
|
||||||||||
Understanding ADO NET
Objectives
- Understand ADO .NET Classes and how to use them effectively in .NET Applications
- Be familiar with how to retrieve and manipulate database content
- Understand how to efficiently implement database access into .NET Applications
- Be familiar with database related error handling
Outline
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
Setup
- Internet Explorer 6 (or equivalent)
- Microsoft Visual Studio .NET
- Internet access preferred
Seminar Pre-Requisites
- Introduction To SQL Sever
- Familiarity with database design and development
Training Materials
- Course Workbook
1.0
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
