Net.IBM.Data.Db2 9.0.0.200

dotnet add package Net.IBM.Data.Db2 --version 9.0.0.200
                    
NuGet\Install-Package Net.IBM.Data.Db2 -Version 9.0.0.200
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Net.IBM.Data.Db2" Version="9.0.0.200" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Net.IBM.Data.Db2" Version="9.0.0.200" />
                    
Directory.Packages.props
<PackageReference Include="Net.IBM.Data.Db2" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Net.IBM.Data.Db2 --version 9.0.0.200
                    
#r "nuget: Net.IBM.Data.Db2, 9.0.0.200"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#addin nuget:?package=Net.IBM.Data.Db2&version=9.0.0.200
                    
Install Net.IBM.Data.Db2 as a Cake Addin
#tool nuget:?package=Net.IBM.Data.Db2&version=9.0.0.200
                    
Install Net.IBM.Data.Db2 as a Cake Tool

About

This package is for connecting to IBM Data Servers from Windows and using .NET 9 as development environment.

Key Features

Support for Microsoft ADO.NET specifications as well as IBM Data Server features.

How to use

Use package manager to add package to the project, build it and deploy it as any other .NET NuGet package based deployment.
In cases where Db2Connect license is needed, the license file needs to be copied to clidriver/license folder as detailed here:
https://community.ibm.com/community/user/blogs/vishwa-hs1/2020/07/12/db2-net-packages-download-and-configure

Main Types

All ADO.NET specification types.

Additional Documentation

IBM Information center for class level documentation  
    https://www.ibm.com/docs/en/db2/11.1?topic=namespaces-ibmdatadb2

What's New

CLI driver upgraded to 12.1.1.0 CSB 54960, please use Db2Connect 12.1 license for this package.
Support for QueryPrefetch keyword enables prefetching of multiple query blocks for a forward only blocked cursor.
KI DT421709 : On Linux platform, stored procedure call failed with SQL0902 error when stored procedure used scrollable cursor to fetch data.
KI DT196972 : DB2DataReader.GetValue() method should return boolean value(True/False) for boolean column data type.

Related Packages

Net.IBM.Data.Db2-lnx : Linux Amd64
Net.IBM.Data.Db2-osx : Mac Arm M1/M2/M3
Net.IBM.Data.Db2-zlnx : Linux on IBM Z (Linux s390x)
Net.IBM.Data.Db2-ppc : Linux ppc64le

Requesting Trial license

Use contact Owner option in NuGet repository for requesting Db2Connect trial license.

To verify connection with this package, may execute TestConn utility from Application bin path:

Usage : TestConn "<ConnectionString>" -f "<FileName>" -v

Requesting support

Please reach out to IBM Tech support for any issues in using this package:
https://www.ibm.com/mysupport/s/?language=en_US
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
  • net8.0

    • No dependencies.

NuGet packages (11)

Showing the top 5 NuGet packages that depend on Net.IBM.Data.Db2:

Package Downloads
IBM.EntityFrameworkCore

IBM Data Server provider for Entity Framework Core. For more details, please visit: https://community.ibm.com/community/user/hybriddatamanagement/blogs/michelle-betbadal1/2020/04/29/getting-started-with-ibm-net-provider-for-net-core

linq2db.LINQPad

Supported databases: IBM DB2 LUW/zOS, Firebird, IBM Informix, Microsoft Access, Microsoft Sql Server (+Azure), Microsoft Sql Server Compact, MySql, MariaDB, Oracle, PostgreSQL, SQLite, SAP HANA, SAP/Sybase ASE, ClickHouse.

FizzCode.EtLast.AdoNet.Db2

ADO.NET extension for EtLast ETL (Extract, Transform and Load) library

ViennaNET.Orm.DB2.Win

Package Description

SnapObjects.Data.Informix

Informix database provider for the SnapObjects ORM (SnapObjects.Data).

GitHub repositories (4)

Showing the top 4 popular GitHub repositories that depend on Net.IBM.Data.Db2:

Repository Stars
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM DB2 Hana Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
testcontainers/testcontainers-dotnet
A library to support tests with throwaway instances of Docker containers for all compatible .NET Standard versions.
linq2db/linq2db
Linq to database provider.
Raiffeisen-DGTL/ViennaNET
Framework for quickly creating enterprise microservices on .NET https://habr.com/ru/company/raiffeisenbank/blog/494830/
Version Downloads Last updated
9.0.0.200 2,841 4/30/2025
9.0.0.100 15,541 12/20/2024
8.0.0.400 6,105 4/4/2025
8.0.0.310 8,265 2/21/2025
8.0.0.300 96,342 8/30/2024
8.0.0.200 113,272 2/8/2024
7.0.0.400 45,319 2/7/2024
6.0.0.500 19,702 4/16/2024
6.0.0.400 17,249 5/15/2023