ADO.NET Programming


The goal of this four-day hands-on course is to demonstrate how to connect applications written in languages such as C#, VB.NET and Managed C++ to a number of data sources such as SQL Server, MySQL, Microsoft Access, Excel and text files.

We discuss how to use the object-oriented classes and functionality in ADO.NET to allow us to connect to databases, extract data from these databases, process the data and update the database with new data. In short, this course deals with the issues that need to be addressed when integrating application-level code with persistent data stores. The percentage theory: practice is approximately 65:35.

What do you learn?

  • A complete overview of the capabilities of ADO.NET and the ADO.NET Entity Framework.
  • Hands-on experience of connected and disconnected classes.
  • How to connect to, and apply SQL commands with SQL Server, Access and MySQL.
  • ADO.NET interoperability with Excel and text files.
  • Advanced issues: stored procedures, parameterised queries, transactions and batches.
  • Multithreading and asynchronous processing.
  • ADO.NET and LINQ (Language Integrated Query) interoperability.
  • Performance tuning and database optimisation.
  • Using C# and Managed C++ to write applications: which one is better?
Basic knowledge of, and familiarity with C#. Practical experience of relational database is also an advantage but not essential.
Who should attend?

This course is suitable for a wide range of software developers who write applications which interface with databases and persistent data and who wish to use ADO.NET and integrate it with these applications.

There are many application areas where it is necessary to access and store persistent data and ADO.NET enables this goal by providing the developer with an easy-to-use interface to a range of popular database systems.


Click here for course contents.


ADO.NET Programming

Fill in your personal details