生成edmx

来源:互联网 发布:java ^ 编辑:程序博客网 时间:2024/06/06 23:19


无需 现在webconfig先配置链接,生成Edmx过程与前者独立,生成完毕以后会在webconfig里面自动补入:

<add name="HmFrameWorkEntities" connectionString="metadata=res://*/HMFW.csdl|res://*/HMFW.ssdl|res://*/HMFW.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=192.168.44.55;initial catalog=HA;persist security info=True;user id=sa;password=123456;MultipleActiveResultSets=True;App=EntityFramework&quot;" 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=&quot;DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.151)(PORT=1521))(CONNECT_DATA=(SID=gzdb)));PASSWORD=dbframework_gz369;USER ID=dbframework_gz&quot;" 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