Before you start
This tutorial is for application developers or DBAs to learn how to access DB2 data from the .NET development environment. It includes step-by-step instructions and screen captures for creating DB2 database objects. These database objects are used in a proof-of-concept application explained in subsequent tutorials in the series. I suggest that you print this tutorial and follow the steps using the system setup explained below.
This tutorial series includes three tutorials (parts). Part 1 introduces the specifications of a proof-of-concept application and its database requirements. It teaches how to create the relational database objects in DB2 Viper using VS.NET 2005. Part 2 teaches how to wire the database back end with a Windows application and a Web application, and present the data on user interface. Part 3 teaches how to use XML data store in DB2 Viper to extend the application capacity and provide the application function in a Web service.
This tutorial is Part 1 of the tutorial series. You will go through a typical scenario for creating a proof-of-concept application called Carpooler. This application is for employees in a corporation to find other employees to carpool with. The application needs data for storing employee and carpool information. For such a purpose, you will use VS.NET 2005 to create DB2 Viper database objects for your application.
In this tutorial, you will learn how to use DB2 Viper and VS.NET 2005 to create database objects for a real-world application.
This tutorial is written for application developers and DBAs whose skills and experience are at a beginning to intermediate level. You should have a general familiarity with using Microsoft Visual Studio.NET development environment. You should also understand basic concepts of relational database, such as tables, views, triggers, stored procedures, keys, and referential integrity.
- Windows operating system supporting Visual Studio.NET 2005.
- Visual Studio.NET 2005 Professional edition or higher. The tutorial is developed using Version 8.0.50727.42, with Microsoft .NET Framework Version 2.0.50727.
- DB2 Viper. The tutorial is developed using DB2 Viper Release Candidate 1. For how to download, check out the Resources section in this tutorial.