Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ASP.NET MVC - Accessing Oracle Database from Visual Studio Express 2015

LetJayBeAug 9 2017 — edited Aug 24 2017

Hello,

I've been trying to connect my ASP.NET MVC 4 project to an existing Oracle database, but to no avail.

I have no problem accessing the DB with sqldeveloper, installed on my development PC, but can't manage to from Visual Studio Express 2015 for Web.

I've read a lot of resources on how to use Entity Framework with an Oracle database, and have added Entity Framework, Oracle.ManagedDataAccess, and Oracle.ManagedDataAccess.EntityFramework to my project with NuGet. However, it doesn't seem to be enough, as I still only get the SQL Server option (and no Oracle) when I try to add a database connection to my application. Every resource I've read tells to install Oracle Developer Tools for Visual Studio, but it is not supported by Visual Studio Express.

What can I do to be able to access the data from my Database through my application, knowing that I can't change my IDE, and that I can only access the database to read its data, but can't modify anything (don't need to, and don't have the authorizations to).

I'm still learning, and I'm sorry if this is somehow a trivial question, but I haven't been able to answer it, despite spending a lot of time reading and trying various methods found around the web.

This post has been answered by Alex Keh-Oracle on Aug 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2017
Added on Aug 9 2017
1 comment
1,568 views