MN303

ADO.NET Programming

87%

overall satisfaction for this course

?Average calculated from scores obtained from 191 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Montreal
  • Laboratory
    course
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to create database applications with ADO.NET.

Targeted audience

Software developers.

Prerequisite

Practical experience withVisual Basic .NET (Course MN204), Visual C# .NET (Course MN201).

Customer Testimonials

Good content. Relevant.

Enrique V. / Programmeur senior, Solutions Consortech inc.

Content

  • Data access technologies comparison: DAO, RDO, ADO, ODBC vs. OLE DB
  • ADO.NET vs. ADO
  • Microsoft Access vs. SQL Server vs. Oracle vs. other databases
  • The ADO.NET framework
  • Connecting to databases
  • Loading data: DataReader
  • Manipulating and updating data: DataAdapter, DataTable and DataSet
  • Handling concurrency (conflicts between multiple users)
  • Using XML with databases
  • Overview of report creation
  • Overview of data access classes

General Note

Note: Although the course examples make use of Visual Basic with Microsoft Access and SQL Server databases, the material also applies to all the .NET languages and to most modern databases.

DATES*

*Unless stated otherwise, all sessions are in French.
  • Montreal

    April 18 to April 19 2017

Trainer(s) assigned(s)

Other course(s) in this category