HP Vertica driver for ADO.NET

This .NET Framework Class Library is provided by HP Vertica. The main functionality of the class library is contained in the file Vertica.Data.dll.

Add a reference to the assembly Vertica.Data and include the Vertica.Data namespace. Instantiate a new VerticaClient connection object. Set the connection string and open the connection.

VB.NET code sample

Imports Vertica.Data
Dim myConnection As VerticaClient = New VerticaClient()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()

C# code sample

using Vertica.Data;
VerticaClient myConnection = new VerticaClient();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();

Description

This driver allows applications written in C# to read data from, update, and load data into HP Vertica databases.

It provides a data adapter (HP Vertica Data Adapter) that facilitates reading data from a database into a data set, and then writing changed data from the data set back to the database. It also provides a data reader (HP VerticaDataReader) for reading data.

The driver requires the .NET framework version 3.5+.

Download NOTE!

More info about this class library can be found at the HP Vertica product page.

Download

This .NET Framework Class Library, HP Vertica driver for ADO.NET, can be downloaded here.

Connection Strings

The HP Vertica driver for ADO.NET class library can be used to connect to the following data sources by using the following connection string references:

Vertica