Skip Ribbon Commands
Skip to main content
Version HistoryVersion History

Course ID

ITC106

Title

ADO.Net Using C#

Price

$1,575.00

Duration

3

Audience

 

Level

 

Delivery Method

 

Software Assurance

 

Microsoft CPE

 

Course Audience

 

Course Objectives

 

Course Description

This three day, intensive course teaches the essential elements of ADO.NET such that, at the end of the course, the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. This three day, intensive course teaches the essential elements of ADO.NET such that, at the end of the course, the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 4.7, Visual Studio® 2015 and SQL Server® 2014.


Course Prerequisites

 

Course Outline

The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies. It includes a discussion of ADO.NET architecture, main interfaces and classes, and programming with both the connected and disconnected models. The database for the case study is introduced. The next two chapters cover in detail Connection and Command objects, which are essential in both connected and disconnected database access scenarios. The following chapter covers DataReaders, which provide a fast, forward-only reading capability. Programming with DataReaders bears a close resemblance to programming with the vintage recordset object. Then the course focuses on the backbone of ADO.NET: DataSet and its related classes, such as DataAdapter, DataTable, DataRow, DataColumn, DataRelation, TableMappings and ColumnMappings. DataSet is able to handle multiple tables while remaining disconnected. It is eminently suited for building highly scalable applications for the Web. The close relationship between ADO.NET and XML is covered in detail. Transactions and concurrency are covered. Additional features of ADO.NET are covered, including asynchronous operations, multiple active result sets and bulk copy. The last chapter covers Language Integrated Query (LINQ) and Microsoft’s Entity Framework.​

Status

Active

Technology

.NET

Category

Microsoft

SubCategory

.NET

Details

 

Attachments

Version: 3.0
Created at 2/20/2018 8:02 AM by Gaige Heiner
Last modified at 3/8/2018 11:02 AM by Gaige Heiner