Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

When will be Oracle Database support for Dotnet Core available?

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.

like image 397
Prasanjeet Debnath Avatar asked Jan 09 '18 15:01

Prasanjeet Debnath


People also ask

Can we use Oracle with ASP NET?

Oracle Developer Tools for Visual Studio is a tightly integrated "add-in" for Visual Studio. This tight integration makes it easy to create ASP.NET Web Applications that access Oracle database without requiring the developer write much code.

Can we use Oracle in Entity Framework?

Yes. See this step by step tutorial of Entity Framework, LINQ, and Model-First for the Oracle database (11G), and using Visual Studio 2010 with .

What is .NET data provider for Oracle?

Oracle Data Provider for . NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, self-tuning statement cache, Application Continuity, and Fast Connection Failover.


2 Answers

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

like image 189
RemiGaudin Avatar answered Nov 10 '22 19:11

RemiGaudin


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

like image 43
Dubo Avatar answered Nov 10 '22 19:11

Dubo