Supported .NET Core ADO Providers

The SQL runtime already includes support for the SQL Server .NET Core provider by virtue of a dependency, the System.Data.SqlClient package.

For other providers, the following table shows the .NET Core providers that Micro Focus has tested with and their corresponding NuGet packages:

Database NuGet Package
IBM DB2 IBM.Data.DB2.Core

IBM provides separate provider packages for Windows and Linux: IBM.Data.DB2.Core for Windows and IBM.Data.DB2.Core-lnx for Linux.

MySQL MySql.Data
Oracle Oracle.ManagedDataAccess.Core
PostgreSQL Npgsql
SQL Server System.Data.SqlClient

This is already included as part of the MicroFocus.COBOL.SqlCLR.Runtime package.

Note: For all of these providers, when defining the TYPE 6 connection string in code, the Factory key value is the same as the package name. See Sample SQL Connection Strings for .NET Core for examples to ensure that you set the Factory key correctly for your provider.