How to get ADONET VerticaTypes for table columns
is there an easy way to get table column VerticaType using the ADONET driver? Currently, I get the column types from a SELECT statement and convert those to ADONET VerticaTypes.
Naively I tried
VerticaType type= (VerticaType)Enum.Parse(typeof(VerticaType), typeName, true);
However, e.g., from v_catalog.columns or v_catalog.types I get "int" or "Integer", but VerticaType is BigInt and, therefore, the above does not work.