ADO.NET 2.0 with C#

Web Tech, UK
Painswick, Gloucestershire, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this course, learn about the features provided by ADO.NET 2.0. Learn to connect to data sources, retrieve and manipulate data, and perform data updates. Examine the various ADO.NET classes, including Connection, Command, DataReader, DataSet, DataTable, DataRelation, and more. 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 stored in a DataSet or DataTable. Become familiar with strongly typed DataSets and learn their advantages. See how to leverage the power of XML through serialization, Diffgrams,and the XMLDataDocument object. Examine new ADO.NET features that support SQL Server 2005 technologies, including asynchronous commands, Multiple Active Result Sets, bulk inserts , and more.
You Will Learn How To
Connect to multiple types of data sources, including SQL Server and Microsoft Jet/Access
Retrieve data, using the DataAdapter, Command, and DataReader classes
Create and configure Command parameters
Cache data using the DataTable and DataSet classes
Apply constraints to DataTable and DataColumn objects
Create relations between DataTable objects, using the DataRelation class
Update data using DataAdapter and Command classes
Work with strongly typed DataSet and DataTable classes
Retrieve and update data using TableAdapter classes
Handle exceptions and data errors, including concurrency errors
Search, sort, and filter data using the DataView class
Work with auto-increment columns in multi-user applications
Retrieve and generate XML data
Take advantage of new SQL Server 2005 features

Course Content
Accessing Data with ADO.NET
The ADO.NET Object Model | Connecting to Data | Understanding Connection Pooling | Using Provider Statistics

Retrieving Data
Introducing Command Classes | Working with Data Readers | Digging Deeper into Commands and DataReaders

Caching Data in DataSets
Populating a DataTable | Filling DataSets Using a DataAdapter | Using the Load Method | Retrieving Schema Information | DataSets and XML

Applying Constraints
Using Constraints | Foreign Key Constraints | Other Constraints

Data Relations
Creating DataRelations | Navigation Pathways | Expressions and Relations | Specifying XML Nesting

Updating Data
Creating Commands with CommandBuilders | Creating Custom Commands | Using Stored Procedures |
Performing Batch Updates

Using Strongly Typed DataSet Classes
Using a Loosely Typed DataSet | Creating a Strongly Typed DataSet | Using a Strongly Typed DataSet | Issues with Using a Strongly Typed DataSet

Handling Exceptions and Data Errors
Using Structured Exception Handling | Handling Provider Errors | Using Transactions | Handling Concurrency Conflicts

Searching, Sorting, and Filtering
The Sample Project | Working with DataTables | Working with DataViews

Handling AutoIncrement Columns
The AutoIncrement Property | Retrieving New Database Values | Avoiding Multi-User Conflicts | Merging Inserted Rows | Other Considerations

XML Techniques
ADO.NET and XML | Saving DataSet Data as XML | Loading XML Data into a DataSet | Working with DataSets and XML Together | Working with XML Data in SQL Server

Features Supporting SQL Server 2005
Enumerating Servers on a Network | Asynchronous Processing | Multiple Active Result Sets (MARS) | Bulk Copy Operations | SQL Server Max Data Types | SQL Server User Defined Types | SQL Server Snapshot Isolation


...''

Phone:+44 (0) 1452 814 303

School Address:

The Old Fleece, Bisley St, GLOS GL6 6QQ UK


Jobs & Resumes: Painswick
Houses & Roommates: Painswick

Search other schools for ADO.NET 2.0 with C# training resources.

VB.NET 2005 - Introduction
VB.NET 2005 - Windows Applications
VB.NET 2005 - ASP Applications
ADO.NET 2.0 with VB
Windows Workflow with VB
C#.NET 2005 - Introduction
C#.NET 2005 - Windows Applications
C#.NET 2005 - ASP Applications
Windows Workflow with C#
XML, XLST and Web Services
XML Development in .NET
.NET Development for Delphi Developers using C#
Delphi 2005 - Upgrade and ASP.NET
SQL Server 2005 for Developers
SQL Server 2005 Reporting Services
SQL Server 2005 Analysis Services
Advanced Delphi Development with SQL Server

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.