Installing the ADO.NET client driver

Prerequisites

The ADO.NET client driver requires the following:

• A supported operating system.

• At least 512MB of memory

• A supported version of .NET Core or .NET Framework. For details, see the Microsoft documentation:

  • Install .NET on Windows
  • Install .NET on macOS
  • Install .NET on Linux

Installation

For a sample application that uses and demonstrates all of these installation methods, see the client-application-examples repository.

Package reference

The ADO.NET client driver is available on NuGet and should be installed with a package reference.

To reference the package, add the following to your .csproj. For an example .csproj file, see SampleApp.csproj:

  <ItemGroup>
    <PackageReference Include="Vertica.Data" Version="23.3.0" />
  </ItemGroup>

Reference a local NuGet package

You can also download the Vertica.Data package and reference it locally:

1. Download Vertica.Data.23.3.0.nupkg from NuGet to project_directory/packages/Vertica.Data.23.3.0.nupkg.
2. Add the following to nuget.config to instruct NuGet to get the package from your local directory:

   <?xml version="1.0" encoding="utf-8" ?>
   <configuration>
     <packageSources>
       <add key="LocalPackages" value="packages" />
     </packageSources>
   </configuration>
   

3. Reference the driver with a standard package reference in your .csproj file:

   <ItemGroup>
     <PackageReference Include="Vertica.Data" Version="23.3.0" />
   </ItemGroup>
   

Reference a local .dll

You can also download the NuGet package, extract the lib/net40/Vertica.Data.dll file, and then reference Vertica.Data.dll:

1. Download Vertica.Data.23.3.0.nupkg from NuGet.org.
2. Extract Vertica.Data.dll to project_directory/lib/Vertica.Data.dll.
3. Reference Vertica.Data.dll in your .csproj file. For example:

  <ItemGroup>
    <Reference Include="Vertica.Data">
      <HintPath>lib\Vertica.Data.dll</HintPath>
    </Reference>
  </ItemGroup>

  <ItemGroup>
    <PackageReference Include="Microsoft.Win32.Registry" Version="5.0.0" />
    <PackageReference Include="System.Configuration.ConfigurationManager" Version="6.0.0" />
  </ItemGroup>