开发ASP.NET MVC+Oracle 11g+EntityFramework无法建立具有检视EF的MVC5控制器
开发环境 Windows 7 64位, Visual Studio 2017 ver15.2(26430.15)
Database Server环境: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Oracle Client 32bit:
http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html
32-bit ODAC with Oracle Developer Tools for Visual Studio Downloads
Oracle Developer Tools for Visual Studio 2017 - MSI Installer
安装Client结果
开发步骤:
1.在VS中新增ASP.NET MVC WebApplication项目.
2.在Models新增项目ADO.NET实例资模型.
3.模型类选来自数据库的EF Designer(Database First).
4.选此数据来源为Oracle并测试连线OK.
5.只能选取Entity Framework 5.0版本.
6.选取数据库对象.
7.Table Schema:
CREATE TABLE ERPPORTAL.TONY_TEST_T
(
ID NUMBER,
TEXT VARCHAR2(400 BYTE)
);
CREATE UNIQUE INDEX ERPPORTAL.TONY_TEST_T_PK ON ERPPORTAL.TONY_TEST_T
(ID);
ALTER TABLE ERPPORTAL.TONY_TEST_T ADD (
CONSTRAINT TONY_TEST_T_PK
PRIMARY KEY
(ID)
USING INDEX ERPPORTAL.TONY_TEST_T_PK);
8.建立Controllers.
出现错误!
解法:
是Oracle Developer Tools 很蠢的没把连线资讯及Driver定义加到web.config里.
用Nuget装这两个, 然后到web.config调整一下连线的IP/NAME, 就可以了
TonyHuang