IBM® Database Add-Ins
for Visual Studio, which provide tools for rapid application development,
database schema development, and debugging, offer even better support
in Version 9.7.
You can use the following enhancements:
- You can install IBM Database Add-Ins for Visual Studio 2008 or
Visual Studio 2010 with an administrator account or non-administrator
account with elevated privileges.
- You can install the 32-bit version of the IBM Database Add-Ins for Visual Studio packaged
with the 64-bit DB2 server and clients.
- The add-ins now support IBM DB2® Version 9.7 for Linux, UNIX,
and Windows. Availability
of some features and data type compatibility depends on the data server
that you use.
- You can use a feature in the add-ins with IBM Optim™ pureQuery
Runtime to capture SQL statements in your .NET applications. You can
then run the SQL statements statically. Using static SQL avoids the
need to prepare certain statements at run time and can improve security
and performance of your applications.
- You can define compound statements in your DB2 SQL procedures.
- You can use trusted contexts during data connections.
- You can choose to use Internet Protocol version
6 (IPv6) format for server addresses in data connections.
- You can use the following Microsoft Visual Studio 2008 features:
- Windows Presentation
Foundation (WPF). You can generate XAML-type applications from database
tables, views, and procedures.
- Windows Workflow Foundation
(WF) integration with Windows Communication
foundation (WCF). You can drag an IBM DB2 custom activity from the WF
project toolbox to the Activity Designer.
- ASP.NET AJAX. You can call ASP.NET Web services from the browser
by using client script.
- You can use localhost data connections without
specifying user IDs and passwords.
- You can group IBM database
objects by schemas in the Server Explorer.
In addition, the add-ins contain additional V9.7
features that enhance working with other IBM data
servers.
DB2 Version 9.7 for Linux, UNIX, and Windows