Configuring a .NET Core Project for SQL Support

This topic describes the steps you will need to perform to create a .NET Core project if you want to take advantage of SQL support.

1. Create your .NET Core project as described in To create a .NET Core project.
2. Install the required NuGet package for the SQL support:
   1. In Solution Explorer, right-click your project and click Manage NuGet Packages.

      The Visual Studio NuGet Package Manager is displayed.

   2. Click the Browse tab.
   3. Select Micro Focus Visual Studio Offline Packages from the Package source drop-down menu.
   4. Select MicroFocus.COBOL.SqlCLR.Runtime from the list of available packages, then click Install.
   5. Click OK on the Preview Changes dialog box, then click I Accept on the License Acceptance dialog box.
   The MicroFocus.COBOL.SqlCLR.Runtime package and any dependencies are added to the current project, listed under References in Solution Explorer.

   Note: If you need to install support for a provider other than the SQL Server .NET Core provider you will need to install an additional NuGet package. See Supported .NET Core ADO Providers for more information.
3. Use the SQL page of the project properties to set your SQL directives as you would normally. See To set COBOL project properties and SQL Properties for more information.