生成edmx
无需 现在webconfig先配置链接,生成Edmx过程与前者独立,生成完毕以后会在webconfig里面自动补入:
<add name="HmFrameWorkEntities" connectionString="metadata=res://*/HMFW.csdl|res://*/HMFW.ssdl|res://*/HMFW.msl;provider=System.Data.SqlClient;provider connection string="data source=192.168.44.55;initial catalog=HA;persist security info=True;user id=sa;password=123456;MultipleActiveResultSets=True;App=EntityFramework""
providerName="System.Data.EntityClient" /></connectionStrings>
oracle生成model :
可以直接在webconfig中添加连接字符串:
<connectionStrings>
<!--<add name="StrConn" connectionString="DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.151)(PORT=1521))(CONNECT_DATA=(SID=XXdb)));PASSWORD=dbframework_gz369;USER ID=dbframework_gz;" providerName="System.Data.SqlClient"/>-->
<add name="AAEntities" connectionString="metadata=res://*/HMFW.csdl|res://*/HMFW.ssdl|res://*/HMFW.msl;provider=Oracle.DataAccess.Client;provider connection string="DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.151)(PORT=1521))(CONNECT_DATA=(SID=gzdb)));PASSWORD=dbframework_gz369;USER
ID=dbframework_gz"" providerName="System.Data.EntityClient"/>
</connectionStrings>
然后再生成edmx.(会发现有链接已经存在不行)
这里面datasource :
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.151)(PORT=1521))(CONNECT_DATA=(SID=xxydb)))
测试连接成功
相关msdn地址:
https://msdn.microsoft.com/zh-cn/library/77d8yct7(v=vs.100).aspx