IBM Data Server Drivers (Db2 Connect Client)

 View Only

Getting started with IBM .NET Provider for .NET Core , .NET 5 and .NET 6

By Michelle Betbadal posted Wed April 29, 2020 03:26 PM

  
The new IBM .NET provider for .NET Core and .NET 5 / .NET 6 is for developing applications using MS .NET Core/.NET 5 / .NET 6 connecting to IBM data servers(namely LUW, IBM i, zOS and Informix)  and applications which run on Windows, Linux and MacOs. The IBM Data Server Providers  packages are available for download in the NuGet repository.

What is new in version 6.0.0.200
  • Tolerance support to Microsoft EntityFramework Core
  • There is a package name and namespace change from Net5.IBM.* to Net.IBM.*. This change will help us to keep the package name and namespace fixed at Net* and only increment the version for future releases including major releases.

What is new in version 5.0.0.300

  • SAVEPOINT support in Transactions
  • Asynchronous support in Entity Framework.

What is new in version 3.1.0.400

  • Critical fixes to previously reported issues
  • Fix to license file issue when connecting from cloud environment to on premise database servers.

What is new in version 3.1.0.200
    
  • Support for MS .NET Core 3.1
  • Code first support for Db2 for z/OS®
  • .NET Core driver on Microsoft Azure
  • Leverage new features of .NET core 2.1
  • .NET Core Driver support for Microsoft Windows Nano Server
  • Db2 .NET Core support on AWS
  

What's new in version 2.0

  • Code First support for EF Core
  • EF Core Code First support for Microsoft Azure scenarios.
  • Support for MS .NET Core 2.1

Whats new in version 1.3 :

  • Support for .NET Standard 2.0 features
  • Deployment support for Db2 .Net core applications on Microsoft Azure.
  • Defect fixes of earlier versions.

Whats new in version 1.2 :

  • Support for macOS. More information available here.
  • .NET Core 2.0 Compatibility.
  • Support for Reverse Engineering. Application can create models from existing database objects. For more information refer here.
  • Support for bin deployment.
  • Support for docker based application development. An example is provided here.

Key features of version 1.1 :

  • Support for .NET Core applications using IBM database servers which run on Linux and Windows.
  • Support for basic database application scenarios (CRUD).
  • Entity Framework support using IBM Entity Framework for IBM Data Servers.
  • Support for writing .NET applications using Entity Framework with existing database objects.
  • Works without any additional driver installation requirement.
  • Integration into IBM Bluemix.  .NET application using IBM dashDB can be developed and hosted in IBM Bluemix.

 

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 databases.
  • There are separate packages for Windows and Linux and Mac.
  • 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[new]

Supported IBM database servers

  • zOS
  • LUW including IBM dashDB
  • IBM I
  • Informix

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 Core or .NET 5 application on Red Hat Openshift environment.
  • Writing and hosting a .NET Core application using IBM dashDB on Bluemix

 VS2017 and VS2019 Support

          Creating .NET Core applications targeting DB2 databases using VS2017 and VS2019 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 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 January 31 2022


#.net
#.NETCore
#.NET5
#.NET6
#EFCore
5 comments
373 views

Permalink

Comments

Thu June 02, 2022 01:57 AM

Hi Daniel, the Db2 .NET packages are for Win x64 and AMD64 on Linux. Support is there for macOS also and packages with -osx in NuGet are for macOS.

Wed May 04, 2022 09:44 AM

Is this x86 architecture only or does it support arm64 on unix/linux/Mac?

Fri July 17, 2020 03:43 AM

Hi Helmet,
 we stopped publishing to NuGet repository and latest packages are available only on IBM downloads.
Please refer to following blog for download information
https://community.ibm.com/community/user/hybriddatamanagement/blogs/vishwa-hs1/2020/07/12/db2-net-packages-download-and-configure

Thanks
Vishwa

Thu July 16, 2020 02:27 AM

NuGet repository is not up-to-date.

Tue June 30, 2020 05:10 PM

The links to the sample applications do not work.