Native Managed .NET Providers

DB2 UDB v8.1 (FP2) ships with a .NET managed provider, IBM.Data.DB2, which is specifically designed to work with DB2 servers. This native managed provider can give you significant performance improvement over the OLE DB and ODBC bridges, and it also provides the ability to exploit the specific features of DB2 servers.

DB2 Managed Provider ADO.NET Objects

The DB2 managed provider classes are similar to Microsoft SQL Server (System.Data.SqlClient) classes. They include the following:

  • IBM.Data.DB2.DB2Connection— This object establishes a connection to a DB2 data source.

  • IBM.Data.DB2.DB2Command— This object executes an SQL statement or stored procedure call against a DB2 data source.

  • IBM.Data.DB2.DB2CommandBuilder— ...

Get DB2® Version 8: The Official Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.