Recently, support for IDS was added to the IBM Database Add-ins for Visual Studio 2005, enabling IDS application developers to use many of the Visual Studio 2005 functionalities. This support enables IDS application developers to reduce development time and develop .NET applications for a wide range of IDS server families using Microsoft® Visual Studio 2005 as their integrated development environment.
Toolbox support with Visual Studio 2003 has been deprecated for use with Visual Studio 2005. IBM Database Add-ins for Visual Studio 2005 is shipped with Informix CSDK, beginning with CSDK 300TC1. The same tooling is also shipped with DB2® clients. The Add-ins versions shipped with Informix CSDK and DB2 are mutually compatible. This article provides an overview of the functionality provided by IBM Database Add-ins for Visual Studio 2005 for Informix.
Please see the Resources section of this article to download the Informix CSDK/IBM Database Add-ins for Visual Studio 2005.
Note: Version 9.x and later server families are supported by this add-in product. Please note that SE engines, 8.x (XPS), 7.x, and 5.x server families are not supported.
IBM Database Add-ins for Visual Studio 2005 highlights
Here are some highlights of the new add-ins:
- Integrated installation: IBM Database Add-ins for Visual Studio 2005 installation is integrated with CSDK 300TC1 installation.
- Server Explorer: There is seamless integration with Microsoft Server Explorer, so that Informix connections can now be added into Microsoft Server Explorer. The IBM Informix .NET provider for .NET framework 2.0 is used for this seamless integration.
- Windows application development: You can build Windows applications for Informix without writing any code through Informix .NET provider for .NET framework 2.0 for 9.x and later IDS families.
The IBM Database Add-ins for Visual Studio 2005 product is integrated with the IBM Informix CSDK product, which also provides you with an option to install the tooling. The last step of the CSDK installation wizard presents a check box provision for this.
Figure 1. Installation screen
Although the installation is integrated with CSDK, IBM Database Add-ins for Visual Studio 2005 appears as a separate product in the Add/Remove Programs utility of the Windows Control Panel.
Figure 2. Installed programs
The installer invokes macconfigchange.exe, which is bundled with the product, and updates the machine.config file by adding entries needed for the Visual Studio Add-ins product. The installer also updates registry entries by calling commontoolreg.exe, which registers the Informix Add-ins package for Visual Studio 2005. Please note that it registers Visual Studio Add-ins for Informix only if it detects .NET framework 2.0 and Informix .NET provider installed on the machine. Once the installation is complete, you can confirm the installation of the Visual Studio add-ins opening Visual Studio 2005 IDE and clicking Help > About Microsoft Visual Studio.
Figure 3. Confirmation of successful installation
Adding connections using Visual Studio add-ins
Informix connections can be added using the Add Connection option from Server Explorer. Follow these simple steps to set up an IDS connection:
- If Server Explorer is not already open, click View > Server
Figure 4. Server Explorer
- From the Data Connections node, right-click and select Add
Figure 5. Add Connection
- Select Data Source, and select IBM Informix.
(You can check the box for Always use this selection, to avoid
this step every time an Informix connection is added.) Click
Figure 6. Select Data Source
- Add the server name, database name, user ID, and password. (You can select
Save password to persist the password across Visual Studio
2005 sessions. You can also opt to Test Connection.) Click
OK. A connection to your database will be added in Server
Figure 7. Add Connection dialog box
- Several features are available in the Server Explorer Add connection
integration that are unique to IBM tools and not available for other databases
in Server Explorer:
Figure 8. FeaturesServer Explorer Add connection integration includes these features:
- It has the ability to automatically refresh a connection when the Visual Studio instance is re-opened. You can make that selection on the Add Connection or Modify Connection dialog.
- Filtering for schema and folders is now simplified to use a LIKE search. Filters for schema apply to all folders. In addition, folder level filters are now supported in the Add Connection or Modify Connection dialogs. Filter values are case sensitive. For example, adding a schema filter value of "IBM" will retrieve all objects starting with schema "IBM" and not "ibm".
- By default, system database objects are not enumerated and will not be listed in Server Explorer; but you can defer this by unchecking the option for "Exclude system schema" in the Add Connection window.
- Application developers may not always be interested in all the default database objects, such as tables, views, procedures, and functions, but rather just a few of them. Add Connection and Modify Connection dialogs allow you to select the folders that interest you. Only the selected folders participate in the pre-fetch operation and schema caching. This selection provides an improved development experience if the developer is using that connection. Please note that since web services are not supported in this release, the Web Services folder is disabled by default.
Server Explorer integration
After adding a new connection, all schema information is asynchronously pre-fetched and cached. This allows rapid access to this information when designing applications. These fetched server objects are listed as folders under the corresponding connection.
Table Enumeration: Expanding the Tables folder will list the tables available in the database, depending upon whether the Filter option or Exclude system schema option is supplied in the Add Connection window. By expanding a particular table, you can see the list of columns with which the table was built.
Figure 9. Table Enumeration
The Property window lists the important properties of the database object selected in the Server Explorer. For example, if you've selected the column "fname" of table "customer" of the stores_demo database, the corresponding Property window would appear:
Figure 10. Properties window
View Enumeration: This is similar to Table enumeration.
Figure 11. View Enumeration
Figure 11. View Enumeration (continued)
Procedure / Function Enumeration: You can view a list of stored procedures and functions by clicking the Procedures and Functions folders respectively. Expanding each stored procedure or function will list the parameters involved. To view the properties of parameters, right-click on the parameter and select Properties. Running stored procedures is currently not supported.
Figure 12. Procedure Enumeration
Figure 12. Procedure Enumeration (continued)
Figure 13. Function Enumeration
Figure 13. Function Enumeration (continued)
Windows application development
Applications can be seamlessly developed for Informix using the new paradigm introduced in Visual Studio 2005 for building Windows applications. Simply follow this procedure to build a Windows application:
- Add a connection to an Informix database.
- Create a new Windows application using the File > New >
Project menu. Call it "customerApp". In this article, let's create
a C# application.
Figure 14. Creating a new C# Windows application
- Create a data source for the customer table.
- Using the top-level menu, choose Data > Add New Data
Source to invoke the wizard.
Figure 15. Add New Data Source wizard
- In the wizard, keep the default selection for "Database". Click Next.
- From the list of connections, select the connection to sample what was
created earlier. Select the option to include sensitive data in the
connection string. Click Next.
Figure 16. Select Database
- Optionally check the box to save the connection string as "stores_demoConnectionString". Click Next.
- Select the Customer table from the list of tables, and
Figure 17. Select Table
- A data source for the Customer table will be added in the Data Sources
window. You can make the Data Sources window visible using the top-level
menu, and selecting Data > Show Data Sources.
Figure 18. Customer DataSource Added
- Using the top-level menu, choose Data > Add New Data Source to invoke the wizard.
- Design the Windows application.
- Ensure the Form1.cs is open in design mode.
Figure 19. Form in design mode
- Drag and drop the department data source from the Data Sources window
onto the form. Notice the default-generated user interface.
Figure 20. Designed Windows form
- Ensure the Form1.cs is open in design mode.
- Run the Windows application.
Figure 21. Running customerApp
You can use the pre-created user interface to navigate the rows. You can also add new rows, delete and update existing rows. Clicking the Save button will save the changes to the server.
Windows application development through DataSet creation
- Using the Microsoft Solution Explorer, right-click on the
customerApp, and select Add > New Item.
Figure 22. Add New Item
- Select DataSet. Click Add. The Microsoft
DataSet designer will open.
Figure 23. Add New DataSet
- From the Microsoft Server Explorer, drag and drop another table, named "orders", onto the open designer. This creates the data source for "orders".
- You can drag and drop the newly created data source onto a fresh form, as mentioned in Steps 4 and 5 of the Windows application development section, by running the form, insert/update/delete operations can be done in the table "orders".
The documentation help for IBM Database Add-Ins for Visual Studio 2005 is integrated into IDE. You can see this in the steps below:
Step 1: Click Help > Contents.
Figure 24. Help
Step 2: Click IBM Database Documentation > IBM Database Add-Ins Help. This documentation contains help for both DB2 and Informix, whereas DB2 specific help pages are marked with .
Figure 25. Contents
Features proposed for future releases
Here are some areas of interest you may wish to explore in future releases of the IBM Informix Visual Studio Add-Ins:
- Support for Web applications
- DDL support
- Script designer
- Show data support with XML import/export
IBM Informix provides new support in the Visual Studio 2005 tooling. The new features include seamless integration with Microsoft Server Explorer and rapid Windows application development for Informix servers that use Informix .NET 2.0 Provider, thereby taking your .NET application developing experience to the next level.
This release of Visual Studio 2005 Add-ins was developed by IBM teams in the Lenexa Lab and the India Software Lab.
- Visit the developerWorks Informix Zone to read articles and tutorials and connect to other resources to expand your Informix skills.
- Visit the IBM Information Management and Visual Studio .NET resource page on developerWorks to read articles and tutorials and connect to other resources to expand your .NET skills.
- Learn more about Informix at the "IBM Informix Dynamic Server v10.00 Information Center.
- Browse the technology bookstore for books on these and other technical topics.
Get products and technologies
- Download a free trial version of Informix Dynamic Server.
- Download IBM product evaluation versions and get your hands on application development tools and middleware products from IBM Information Management, Lotus®, Rational®, Tivoli®, and WebSphere®.
- Download IBM Informix CSDK for Windows from the Informix Client Software Development Kit.
- Participate in the discussion forum.
- Check out developerWorks blogs and get involved in the developerWorks community.