ASP.NET MVC和Oracle DB(12C)之间的互操作 [英] Interoperate between ASP.NET MVC and Oracle DB (12c)
问题描述
我有Oracle数据库和ASP.NET MVC之间存在着严重的问题:如何使用Oracle数据库在Visual Studio?
我的环境是:
Oracle数据库(12C)
视觉STDIO 2015年
10的Windows与VMware
使用ASP.net MVC实体框架连接Oracle数据库数据
块引用>我如何获得ASP.NET MVC(的WebAPI)与Oracle数据库(12C)?
正常工作解决方案如何创建ASP.NET MVC与Oracle数据库,并作为下面一步步来告诉你如何处理这个问题。
第一步。下载 ODAC 并安装它
结果
第二步。下载 Oracle开发工具Visual Studio的2015年并安装它
步骤2.5:重新启动OS
第三步:配置NET连接别名。要复制tnsnames.ora中到另一个文件夹像下面的图片和修改连接数据
HTCE7 =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.168.203)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = misutf8)
)
)第四步:使用的NuGet在Visual Studio安装Oracle组件像下面的图片结果
PS: http://www.oracle。 COM / technetwork /主题/ DOTNET /高科技,信息/ 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:
Oracle DB (12c)
Visual Stdio 2015
Windows 10 with VMware
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 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
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屋!