ADO.NET Provider for DB2

Build 24.0.9060

Using ADO.NET

This section provides a walk-through of writing data access code to DB2 in ADO.NET.

Connecting from Code

See Establishing a Connection for the prerequisite information you need to deploy the provider and configure the connection to DB2. Connecting from Code shows how to connect with the classes DB2Connection, DB2ConnectionStringBuilder, and, in ASP.NET, DB2DataSource.

Discovering Schemas

You can use the classes detailed in Schema Discovery to discover the table schemas at run time. You can also query the available System Tables to retrieve schema information, data source information, and other data provider metadata.

Executing SQL

You can use native ADO.NET interfaces to execute data manipulation SQL to DB2: Querying with the DataReader and Querying with the DataAdapter provide code examples and guides to using native ADO.NET interfaces to access DB2 data. Results can be processed from the DataTable instance filled or from the DataReader returned.

Modifying the Data shows how to use the provider to update changes to a data set.

Connection Pooling

Instantiate pooled connections by configuring the connection string. See Connection Pooling to create and configure a pool.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060