Course Features

  • Lectures 30
  • Quizzes 0
  • Duration 15 day
  • Skill level Mid Level
  • Language English
  • Students 5
  • Assessments Yes
Yuvaraj Karuppusamy

Creative Head


0 Review

Course Details

The course opens with an overview of ADO.NET and its relation to previous Microsoft data access technologies, including ADO. 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 enterprise applications.

Transactions and concurrency are covered. The course concludes with a hands-on treatment of additional new ADO.NET features in .NET.


ADO.NET Using C#
  • The close relationship between ADO.NET and XML is covered in detail.
  • There is a practical discussion of data binding including new features in .NET.
  • The labs use console client programs.
ADO.NET for Windows Applications Using C#
  • There is a practical discussion of data binding including new features in .NET.
  • The labs use Windows Forms client programs.
  • For students pursuing MCTS certification, the course provides helpful preparation for Microsoft Exams on .NET Framework - Windows-Based Client Development.
ADO.NET for Web Applications Using C#
  • This version discusses issues related to building effective database applications for the Web.
  • The case study demonstrates the use of ADO.NET and ASP.NET.
  • The labs use ASP.NET client programs.

What you'll learn

  • Understand the architecture and main classes of ADO.NET
  • Gain fluency in programming ADO.NET using C#
  • Gain a thorough understanding of the use of disconnected DataSets for building highly scalable applications
  • Acquire a working knowledge of the tight coupling of XML with ADO.NET
  • Learn how to use new features in ADO.NET with Visual Studio and SQL Server
  • Implement a realistic case study that ties together all the concepts of ADO.NET in a practical demonstration

Yuvaraj Karuppusamy Creative Head

He is the Professor of the Department of Computer Applications at Gobi Arts & Science College where he has been since 2013. He also currently serves as Creative Head of Techi4s Soft Solutions. During 2013-2018 he was worked as Developer,Trainer and etc.,

0.00 average based on 0 ratings

5 Star
4 Star
3 Star
2 Star
1 Star