The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Develop proof-of-concept .NET applications, Part 1: Create database objects in DB2 Viper using .NET

Walk through a quick application prototype

Chenhong Xia (xia@us.ibm.com), User-Centered Design, IBM

Chenhong Xia graduated from NMSU with a Ph.D. in Cognitive Psychology, specializing in human-computer interaction. She is currently working at IBM as a usability specialist for DB2 and Rational products. Chenhong is an IBM Certified Database Associate in DB2 Universal Database, and a Microsoft Certified Professional in .NET. She is also UCSC-certified in object-oriented analysis and design. Her main interests include snowboarding, poetry, creative writing, and software architecture, with a zest for helping users understand IBM products.

Summary: This tutorial series teaches you how to create proof-of-concept Windows® and Web applications to access relational and XML data in IBM DB2® Viper, using Microsoft® Visual Studio.NET® 2005. Part 1 explains the application specifications and illustrates how to create the relational database objects required for the application. You will learn how to create tables, views, triggers, and stored procedures, using a sample carpooling application.

View more content in this series

Date: 11 May 2006
Level: Intermediate
PDF: A4 and Letter (1313 KB | 26 pages)Get Adobe® Reader®

Activity: 12457 views
Comments:

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.

About this series

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.

About this tutorial

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.

Objectives

In this tutorial, you will learn how to use DB2 Viper and VS.NET 2005 to create database objects for a real-world application.

Prerequisites

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.

System requirements

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.