Is there a Vertica provider for any ORM (preferably EF) for OData in .Net

rjayabalan

I am new to Vertica. I am exploring options to expose data in Vertica using OData and .Net framework. I do not see any Vertica data provider for Entity Framework (EF) to generate Entity Data Model (EDM). Any pointer in this direction would be of great help to me.

twall

Vertica's ADO.NET client does not implement the extensions required to support the entity framework. You might be able to implement a basic one of your own by following something like https://github.com/npgsql/efcore.pg, but it may be a fair amount of work. I don't know the framework well enough to say how much effort it would really take.

If your end goal is to have an OData interface to your data, I have heard of people having some success with Apache Olingo on top of JDBC, but that would be a java solution and not a .NET one. The .NET world may have something similar that does not require entity framework support but I don't know enough to say for certain.