DB2 and .NET II

I had request for more info on this, so I went to the IBM booth and asked for a demo of it.

Basically, you can do with .NET the same stuff you can do with Java in DB2, which is define a DB2 stored procedure and attach to it a static method in a .NET class, so there is not much to say about it...

They made a lot of work in integrating this in VS.NET, so you have a wizard that lets you select the method you want to expose as a stored procedure, let you map the data types (ie, what DB2 type is System.String?) and it generates the DLL commands to add the stored procedure to the database. Then you can call it as any stored procedure.

The interesting thing was that when defining the stored procedure, you had to specify 'JAVA' as a language, they had a switch that says 'when it says Java then it means .NET' ;).