Before you start
The IBM Certified Application Developer certification confirms to others that you are an intermediate- or advanced-level IBM DB2 for Linux™, UNIX®, and Windows® application developer and shows that you have strong skills in all common programming tasks as well as embedded SQL programming, ODBC/CLI programming, .NET programming, or Java™ programming.
This series of nine free tutorials is designed to help you prepare for the DB2 9 Application Development for Linux, UNIX, and Windows certification exam (Exam 733). Each tutorial includes a link to a free DB2 9 for Linux, UNIX, and Windows trial download. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
In this tutorial, you will learn about writing .NET applications that interface with IBM DB2. You will see how to:
- Connect to a DB2 database from a .NET application
- Use ADO.NET to read and update data in a DB2 database
- Use ADO.NET to work with results
- Build an ADO.NET application
- Troubleshoot a DB2 .NET application
The material in this tutorial covers the objectives in Section 6 of the DB2 9 Application Developer Certification exam (Exam 733), entitled ".NET Programming."
To take the DB2 9 Family Application Development exam, you must have already passed the DB2 9 Family Fundamentals exam (Exam 730). You can use the DB2 9 Family Fundamentals tutorial series to prepare for that test. It is a very popular tutorial series that has helped many people understand the fundamentals of the DB2 family of products.
In addition to this DB2 background, you should also have basic knowledge of SQL and the .NET platform before you begin this tutorial.
This tutorial is one of the tools that can help you prepare for Exam 733. You should also review the Resources section at the end of this tutorial for more information.
You do not need a copy of DB2 Universal Database to complete this tutorial. However, you can download a free trial version of DB2 9 Enterprise Edition if you wish.
If you plan to develop .NET applications for DB2, or you plan to try out this tutorial's sample code yourself, you need to complete the following tasks:
- Install DB2 9 for Linux, UNIX, and Windows
- Create the sample database by running
db2samplfrom the DB2 CLP. The sample code in this article has been written to work with this database.
- Install Microsoft® Visual Studio .NET 2003 or later