Skip to main content
Question

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

  • December 4, 2019
  • 1 reply
  • 13 views
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.

    1 reply

    twall
    Forum|alt.badge.img
    • twall
    • Participating Frequently
    • December 4, 2019

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement