Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

When will be Oracle Database support for Dotnet Core available?

Tags:

.net

.net-core

oracle

oracleclient

system.data.oracleclient

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
Sign in to Comment

Related questions

Getting ambiguous reference error in C# app due to cref reference in comments?
Given a hwnd, determine if that window is not hidden by other windows (Z-Ordering)
Windows.Forms.RichTextBox Loses table background colours
Performance of typeof(String) vs System.Type.GetType("System.String")
Where is the Upgrade Path for C# 6.0? Is it safe yet?
Check Table Exist Before Create Table On FluentMigrator
What's the difference between MemberInfo FieldInfo
Why is Roslyn generating a > comparison instead of a != one here?
What exactly is "lightweight COM"?
Configure .NET Core to use x86 SDK
ResizeEnd event is not triggered when resizing the form by maximize button?
Async requests with .NET core
How to verify if Zebra printer successfully printed using ZPL and C# (or be able to detect errors)?
Is it bad practice to include .exe files in a Nuget package?
New dotnet core project cannot restore
.NET4 ExpandoObject usage leaking memory
Can `typeof(T).IsAssignableFrom(x.GetType())` be safely rewritten as `x is T`?
Xunit and Mock data with Moq
Where vs. foreach with if - why different results?
Cannot add System.Configuration.ConfigurationManager to .NET core application

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!