Search code examples
.netasp.net-coreverticaasp.net-core-webapi

.Net core support for querying Vertica

I want to connect to Vertica DB from .Net Core app but the Vertica.Data package is not compatible with .Net Core. Have been searching for another package which works for .Net core but did not find anything. Is there any other workaround to query Vertica from .Net core app?

Solution

  • You can use Vertica.Data package from Nuget provided by HP Vertica in .net core 2.1+,

    while build it shows warning 

    "Package Vertica.Data was restored using .NETFramework instead of target framework .NETCoreAPP"

    but it works fine, I didn't test it in production though.

    use it using

    using Vertica.Data.VerticaClient;

    update

    It works when you deploy in Windows environment, but in Linux environment it does not work.