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();
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+.
Login to the myVertica portal and click the download tab.
More info about this class library can be found at the HP Vertica product page.
This .NET Framework Class Library, HP Vertica driver for ADO.NET, can be downloaded here.
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: