Interoperate between ASP.NET MVC and Oracle DB (12c)

asp.net-web-api entity-framework-6 oracle12c virtual-machine visual-studio-2015

Question

I do have a serious problems with between Oracle DB and ASP.NET MVC: How to use Oracle DB in Visual Studio?

My environment is:

  1. Oracle DB (12c)

  2. Visual Stdio 2015

  3. Windows 10 with VMware

  4. Use ASP.net MVC with Entity Framework to connect Oracle DB Data

How can I get ASP.NET MVC (WEBAPI) to work properly with Oracle DB (12c)?

1
4
5/24/2016 8:11:24 AM

Accepted Answer

How do I create ASP.NET MVC with oracle DB, and as following step by step can tell you how to deal with this issue.

Step1. Download [ODAC](http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html) and install it enter image description here
enter image description here

Step2. Download Oracle Developer Tools for Visual Studio 2015 and install it

enter image description here

Step 2.5: Restart OS

Step3:Configuring a NET Connect Alias. to copy tnsnames.ora to another folder like as below pictures and modify your connection data

C:\app\client\williehao\product\12.1.0\client_1\Network\Admin

enter image description here enter image description here

   HTCE7 =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.168.203)(PORT = 1521))
            (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = misutf8)
            )
          )

Step4: using nuget in Visual Studio to install oracle components as like below picture.
enter image description here

Step5: you can see the ODP.NET in you connection properties enter image description here

PS: http://www.oracle.com/technetwork/topics/dotnet/tech-info/odac12cr3ds-2390548.pdf

6
6/3/2017 3:56:07 AM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow