Connect to Oracle database from asp.net core

Question

First off I have read other posts about connecting to an Oracle database, unfortunately they could not help me. I'll describe what I have tried and hopefully someone can point me in the correct direction.

First off I tried to install ODTwithODAC122010 as many sources are saying,but this one gives me a few process exited with non zero exit code. It says it's successful but nothing seems to be changed.

Next to that I tried installing ODTforVS2017_122010.exe I have an updated Visual Studio professional. It says the installation is a success. This however does not seems to add any option like tutorials describe. With this I mean that there should be something visible in;

visual studio tools -> connect to database -> Oracle database, data provider menu should have something like Oracle for.. This doesn't show up unfortunately..

So I tried connecting to the database in my visual studio project selecting the .net framework data provider for oracle. Here three fields are asked: Server name username and password. I tried filling them in but it couldn't connect. For server name I used: IPADDRESS:PORT/SERVICENAME

After that I gave up hope for connecting to the database through visual studio (I can connect to the database using oracle SQL developer).

Then I installing the following nuget packages: - Oracle.ManagedDataAccess - System.Configuration.ConfigurationManager - System.Security.Permissions - System.Security.Principal

And wrote a piece of code to connect to the database like:

using(OracleConnection connect = new OracleConnection(ConnectionDetails.returnConnectionString()))
{
    connect.Open();
    Console.WriteLine("did it work?" + connect.ServerVersion);
}

Where returnConnectionString returns:

"User Id=MYID;Password=MYPASSWORD;Data Source=IPADDRESS:PORT/SERVICENAME"

Unfortunately when I try to run this I'm facing a ExecutionContext.cs not found. This is happening at connect.open();

I'm launching this code at:

    public static void Main(string[] args)
    {
        var a = new DatabaseConnector();
        a.test();
        BuildWebHost(args).Run();
    }

As I final word I want to make it clear that I'm using ASP.NET Core and that your suggestions and help will be greatly appreciated!

Sathishkumar · Accepted Answer · 2018-06-19 13:40:29Z

7

To be precise,

Right click on your project
Go to Manage NuGet packages
Search for Oracle.manageddataaccess.core . You will get Nuget package 2.12.0-beta2 version. Add it.
In the page, import as below to access oracle classes

using Oracle.ManagedDataAccess.Client;

This is a beta version of Oracle data access provider and PROD version is supposed to be available at the end of 3rd quarter of 2018.

answered Jun 19, 2018 at 13:40

Sathishkumar

861 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roy Sanchez · Accepted Answer · 2018-02-06 18:32:18Z

1

There's currently no ODP.NET support for .NET Core, it was suppose to be released last year, but there's been no news more than and it's coming tweet from the ODP twitter account a couple of weeks ago.

You can make the current version work by moving your project from .netcoreapp2 to a net461 or higher target framework, but it would remove the cross platform support from your project.

In order to move your project to .net461 or any other follow this steps:

Edit your csproj file and replace the TargetFramework with net461
If you have a web project then remove the Microsoft.AspNetCore.All package and install the Microsoft.AspNetCore (which should download the others dependencies).

answered Feb 6, 2018 at 18:32

Roy Sanchez

8546 silver badges14 bronze badges

Comments

S B · Accepted Answer · 2018-04-05 07:06:51Z

0

At the time of asking this question there was no driver Roy Sanchez answered that. A few weeks the driver got released on the oracle site and a as a nuget package.

answered Apr 5, 2018 at 7:06

S B

3091 gold badge2 silver badges10 bronze badges

Collectives™ on Stack Overflow

Connect to Oracle database from asp.net core

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related