Integration of DB2 and .Net framework ::::
Developing IBM Data Server Provider for .NET Applications
The IBM Data Server Provider for .NET provides functionality for connecting to a database, executing commands, and retrieving results. Those results can be processed directly, or placed in an ADO.NET DataSet for further processing while in a disconnected state. While in the DataSet, data can be exposed to the user, combined with other data from multiple sources, or passed remotely between tiers. Any processing performed on the data while in the DataSet can then be reconciled to the database.
To use the IBM Data Server Provider for .NET, you must add an imports or using statement for the IBM.Data.DB2 namespace to your application .DLL. For example:
[Visual Basic]
Imports IBM.Data.DB2
[C#]
using IBM.Data.DB2;You also must include a reference to IBM.Data.DB2.dll in your appication's project. In Visual Studio you can do this either from the References section for your project in the Solution Explorer, or from the Project > Add Reference menu option. If you are compiling a program from the command line for Framework 2.0 or 3.0, your csc or vbc commands should include the following option:
/r:"%DB2PATH%"\bin\netf20\IBM.Data.DB2.dllIf you are compiling a program from the command line for Framework 1.1, your csc or vbc commands should include the following option:
/r:"%DB2PATH%"\bin\netf11\IBM.Data.DB2.dll
Please ensure that your PATH is set to one of the dll(as per requirement) in DIR: C:\Program Files\IBM\SQLLIB\BIN\netf20
Before executing any command for interaction between IBM database and .Net
You could also install the Add-ons for VS.net shipped with DB2(Not sure if with all versions of DB2).
Commands for interaction between DB2 and .Net do have specific names- Please refer
https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
---search for IBM.Data.DB2.Namespace
--> Which has all commands/syntax supported by DB2 for .net applications
Could find the same with MSDN library.
Regards
-- Sanjay