7

I want my DotnetCore 2.0 application to connect to Oracle, however, I am not able to find any official documentation from Oracle support. It was expected to release by the end of the year 2017 as per this link http://www.oracle.com/technetwork/topics/dotnet/tech-info/odpnet-dotnet-core-sod-3628981.pdf but it is still not available.

We are trying with other unofficial libraries (dotNetCore.Data.OracleClient) to connect to oracle as per this thread How to connect to an Oracle database Connection from .Net Core but it has many limitations like

  1. we are unable to call the stored procedures with all the parameters
  2. dotnet parameters types like ref is not available while calling

We have our existing database in Oracle and application in DotNet 4.6. We are going to rewrite our application in Dotnet Core that uses oracle database.

Prasanjeet Debnath
  • 272
  • 3
  • 13
  • 3
    I'm afraid nobody here can see the future. Of the two guys that could, one mysteriously vanished and the other cashed in on two winning lottery tickets and lives on a beach somewhere. – nvoigt Jan 09 '18 at 16:20

2 Answers2

6

There is now an official Data Provider for .NET Core published by Oracle on nuget.

Rémi Gaudin
  • 414
  • 10
  • 14
5

Beta release .Net Core Managed driver released by Oracle at the end of January 2018 http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html. Supported platform mentionet in doc is now Win and Linux.

Nuget: https://www.nuget.org/packages/Oracle.ManagedDataAccess.Core

More options there: https://stackoverflow.com/a/45969150/1642907

Dubo
  • 381
  • 3
  • 7