ASP.NET MVC和Oracle DB（12c）之间的互操作 [英] Interoperate between ASP.NET MVC and Oracle DB (12c)

问题描述

我在Oracle DB和ASP.NET MVC之间确实存在严重问题：如何在Visual Studio中使用Oracle DB？

我的环境是：

1. Oracle DB（12c）




2. Visual Stdio 2015




3. / p>




4. 使用ASP.net MVC与实体框架连接Oracle数据库数据

如何使ASP.NET MVC（WEBAPI）与Oracle DB（12c）正常工作？

解决方案

如何用oracle DB创建ASP.NET MVC，如下一步可以告诉你如何处理这个问题。

Step1。下载[ODAC] （

Step2。下载

步骤2.5：重新启动OS

步骤3：配置NET Connect别名。将tnsnames.ora复制到另一个文件夹，如下图所示，修改连接数据

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

  HTCE7 = 
（DESCRIPTION = 
（ADDRESS =（PROTOCOL = TCP）（HOST = 192.168.168.203）（PORT = 1521））
（CONNECT_DATA = 
（SERVER = DEDICATED）
 （SERVICE_NAME = misutf8）
）
）
  

步骤4：使用nuget在Visual Studio中安装或acle组件如下图所示。

步骤5：您可以在其中查看ODP.NET连接属性

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

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)?

解决方案

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

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

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

   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.

Step5: you can see the ODP.NET in you connection properties

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

这篇关于ASP.NET MVC和Oracle DB（12c）之间的互操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！