Level: Intermediate Sonali Surange (ssurange@us.ibm.com), Developer, IBM
27 Apr 2006 Exposing and consuming information from databases as Web services is becoming a key requirement for businesses implementing heterogeneous scalable solutions. IBM® Database Add-ins for Microsoft® Visual Studio 2005 supports exposing DB2® Universal Database™ (DB2 UDB) information as Web services without writing any code. This unique feature available in IBM tools allows database developers to improve their productivity when implementing service oriented architectures.
In this tutorial
- You will walk through the creation of the schema for the IBM Redbooks library application.
-
You will generate Web services for tables and procedures in your connection.
-
You will test the generated Web services for tables and procedures. This step also performs initial preparation steps required to build the LibraryApplication. Analysis of the Web service code generated and the test results are provided.
-
You will create an application to consume the Web services generated by IBM tools.
- Finally, you will test the IBM Redbooks application.
Prerequisites
You must be familiar with DB2 databases and Visual Studio .NET.
System requirements
Download and install the IBM Database Add-ins for Visual Studio 2005 Refresh. For download and install instructions, please visit the developerWorks Information Management Visual Studio .NET zone. Download the
IBM Database
Add-ins for Visual Studio .NET 2005.
Download a free trial version of
DB2 UDB Enterprise Server
Edition.
Duration
1 hour
Formats html, pdf
Introduction
Using Visual Studio 2005 greatly simplifies the task of building ASP .NET Web services for DB2. This tutorial describes the process of building and deploying ASP .NET® Web services using IBM tools. You will create a IBM Redbooks library application implementing and consuming Web services to demonstrate the ease of use IBM tools provide to create such applications. This tutorial also highlights the usability improvements made in the IBM Database Add-Ins for Visual Studio 2005 since the first Developer Release in December 2005.
|