Updating ADO.NET Client Code From Previous Driver Versions

Starting in release 5.1.1, the Vertica client drivers have been updated to improve standards compliance, performance, and reliability. As a result, some Vertica-specific features and past incompatibilities have been eliminated. You must update any client code written for the prior versions of the ADO.NET driver to work with the version 5.1.1 driver and beyond.

Auto Commit Change

Performance Improvements

Namespace Change

Connection Properties

Result Buffering

Logging Changes

Data Type Changes

The following data types have changed:

Old Datatype Name New Datatype Name
verticaType.Integer
VerticaType.BigInt
verticaType.Bigint
VerticaType.BigInt
verticaType.Timestamp
VerticaType.DateTime
verticaType.Interval

Changed to specific type of interval, for example:

  • VerticaType.IntervalDay
  • VerticaType.IntervalDayToHour
  • VerticaType.IntervalDayToMinute
  • etc.
verticaType.Real
VerticaType.Double
verticaType.Text
VerticaType.VarChar
verticaType.Smallint
VerticaType.BigInt
verticaType.Varbinary
VerticaType.VarBinary

Multiple Commands Now Supported

Multiple commands in a single statement are now supported, provided that parameters are not used in any of the commands in the statement. The exception is COPY commands. You cannot issue multiple COPY commands in the same statement.