Installing the ADO.NET client driver

The ADO.NET client driver requires the following:.

Prerequisites

The ADO.NET client driver requires the following:

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>