Data Management Global

The IBM .NET provider for .NET 6/.NET 7 and .NET 8 is for developing applications using MS .NET .NET 6/.NET 7 and .NET 8 connecting to IBM data servers (namely LUW, IBM i, zOS and Informix)  and applications which run on Windows, Linux, MacOs, Linux on IBM z and Linux on Power(ppcle). The IBM Data Server Provider NuGet packages are available for download in the NuGet repository. Please note, only listed Db2 .NET NuGet packages are supported and to be used. Other older packages may be deprecated from time to time without any prior notice. It is done to either follow Microsoft .NET support policy or to discontinue older packages when a new version is available.

What is new in 

Db2 .NET 8.0.0.200

• Support for .NET 8  
• Fix to crash issue noticed in version 8.0.0.100.

IBM EntityframeworkCore 8.0.0.200

• Support for EntityframeworkCore 8.0
• Fix to crash issue noticed in version 8.0.0.100
• Upgrade of clidriver to v11.5.9

Db2 .NET 7.0.0.400

• Fix to previously reported Access Violation exception in 7.0.0.300.

Db2 .NET 6.0.0.500

• Fixes to previously noted issues
• Upgrade of dependent clidriver to v11.5.9.

Net.IBM.Data.Db2-zlnx

• Support for .NET on Linux on IBM Z

Net.IBM.Data.Db2-ppc

• Support for .NET on Linux on Power (ppc64le)

Since Db2 tracing on many advanced deployment scenarios may vary from regular db2 tracing, a separate page is created to list some of them and provide details on how to capture db2 trace. The blog can be accessed here.

Instructions for downloading and using the package

    The following are the prerequisites for using the package

• Any other IBM DB Drivers should not be present in the machine.
• Path/LD_LIBRARY_PATH needs to be updated to include the package driver path.

     Apart from this, the download links and other commonly asked questions are listed in the Frequently Asked Questions. 

Points to remember for using this package:

• The license needed for connecting to DB2 databases remains the same as that of the DB2Connect for IBM Data Servers.
• There are separate packages for Windows and Linux, Mac, Linux on IBM Z and Linux on Power.
• Most of the features of MS ADO.NET like Connection, Command, DataReader and server specific data types are supported.
• The ADO.NET features which are excluded in MS .NET Core are not available in IBM .NET Core.

Supported platforms and OS:

• Windows 64-bit
• Linux AMD64
• macOS
• Linux on IBM Z
• Linux on Power(ppc64le)

Supported IBM database servers

• zOS
• LUW 
• IBM I

Examples and samples

• Writing a sample Console application using IBM .NET provider for .NET Core and using IBM databases. 
• Writing a sample MVC application using IBM .NET provider for .NET Core and using IBM databases. 
• Creating Azure Functions using IBM .NET Provider for .NET Core
• Deploy a .NET 6 or .NET 8 application on Red Hat OpenShift environment. Though the blog is based on .NET Core 3.1, its applicable to .NET 8 also.

Latest Visual Studio Version Support

          Creating .NET Core applications targeting DB2 databases using VS2017, VS2019 and VS2022 is also supported. Please follow the Sample IBM DB application using VS2017 to create a sample test application with VS2017 as an example. Similar steps are applicable to VS2019 and VS2022 also.

Other features which are not yet there in this release

    Some of the features are not yet supported in this release. The Limitations page lists it.

Last updated On 6th June 2024

#DataManagementGlobal
#DataServerDrivers