Application development with .NET - DB2 Express-C: The Developer for XML, PHP, C/C++, Java, and .NET - page 279

DB2 .NET Data
Provider

DB2 OLE DB Data
Provider

DB2 ODBC Data
Provider

Connection Object
(Used to create
connection)

DB2Connection System.Data.ODBC ODBCConnection

Command Object
(Used to execute
command)

DB2Command OleDbCommand ODBCCommand

DataReader
Object (Used to
read retrieved
data)

DB2DataReader OleDbDataReader ODBCDataReader

DataAdapter
Object (Used to
load and unload
data between
DataSet and
database)

DB2DataAdapter OleDbDataAdapter ODBCDataAdapter

ConnectionString Database=

SAMPLE

PROVIDER=IBMDA
DB2;DSN=SAMPLE
;UID=db2admin;PW
D=db2admin

DSN=SAMPLE;UID
=db2admin;
PWD=db2admin;
DRIVER={IBM DB2
ODBC Driver}

Transaction Object DB2Transaction OleDbTransaction ODBCTransaction

OLE DB Data provider and ODBC Data Provider have limitations. Refer to
following URLs for complete listings:
OLE DB Data provider limitations
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/
com.ibm.db2.udb.apdv.ms.doc/doc/r0011826.htm
ODBC Data Provider limitations
http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/
com.ibm.db2.udb.apdv.ms.doc/doc/r0011829.htm

6.5 Application example using ADO.NET

In this section, we provide sample C# application codes, which utilize IBM DB2
.NET Data provider to demonstrate inserting new customer data into the