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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.