Level: Intermediate Peter He (peterzh@ca.ibm.com), DB2 Consultant, IBM
01 Mar 2007 Learn about writing .NET applications
that interface with IBM® DB2®. Get an introduction to the ADO.NET object model and
see how to execute SQL statements with ADO.NET. This is the sixth in a series of
nine tutorials that you can use to help prepare for the IBM DB2 9 Family
Application Development certification exam (Exam 733).
Objectives - Learn about writing .NET applications that interface with IBM DB2
- 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
Prerequisites
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 Family Fundamentals tutorial series" to prepare for that exam. It is a very popular series that has helped many people understand the fundamentals of the DB2 family of products. Although not all materials discussed in the Family Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should have a basic knowledge of:
- DB2 instances
- Databases
- Database objects
- DB2 security
In addition to this DB2 background, you should also have basic knowledge of
SQL and the .NET platform before you begin this tutorial.
System requirements
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
db2sampl from 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
Duration
Less than two hours
Formats html, pdf
Tutorial overview
This is the sixth in a series of nine tutorials that you can use to help prepare
for the DB2 9 Family Application Development Certification exam (Exam 733). The
material in this tutorial primarily covers the objectives in Section 6 of the exam,
entitled "".NET Programming."
| 
