Supported .NET Providers

Describes the .NET providers available for use with SQL.

ADO

Important: When using the ADO MicroFocus.COBOL.SqlCLR.Runtime package with the SQL(DBMAN=ADO) directive, you must use a TYPE 6 connection string. See Sample SQL ADO Connection Strings for .NET for examples.

The following table shows the .NET providers that Micro Focus has tested with and their corresponding NuGet packages:

Database	NuGet Package
IBM DB2	Net.IBM.Data.DB2 IBM provides separate provider packages for Windows and Linux: Net.IBM.Data.Db2 for Windows and Net.IBM.Data.Db2-lnx for Linux.
MySQL	MySql.Data
Oracle	Oracle.ManagedDataAccess
PostgreSQL	Npgsql
SQL Server	Microsoft.Data.SqlClient This is already included as part of the MicroFocus.COBOL.SqlCLR.Runtime package via a dependency.

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

ODBC

When using either the ODBC MicroFocus.COBOL.SQLODBC32.Runtime package or the ODBC MicroFocus.COBOL.SQLODBC64.Runtime package with the SQL(DBMAN=ODBC) directive, you can use any type of connect statement.