EntityFramework默认只支持SQLServer数据库,如果想要支持其他数据库,要安装相应的插件。 如支持Oracle,要安装Oracle Data Access Components (ODAC),支持MySQL要安装mysql-connector-net-6.4.6等 下面列举下3种数据库下的配置: 1.SQLServer: connectio
EntityFramework默认只支持SQLServer数据库,如果想要支持其他数据库,要安装相应的插件。
如支持Oracle,要安装Oracle Data Access Components (ODAC),支持MySQL要安装mysql-connector-net-6.4.6等
下面列举下3种数据库下的配置:
1.SQLServer:
<connectionstrings> <add name="EntityDesignEntities" connectionstring="metadata=res://*/EntityDataModel.EntityDesign.csdl|res://*/EntityDataModel.EntityDesign.ssdl|res://*/EntityDataModel.EntityDesign.msl;provider=System.Data.SqlClient;provider connection string=" data source=".;initial" catalog="DevBase;persist" security info="True;user" id='sa;password=xxx;multipleactiveresultsets=True;App=EntityFramework""' providername="System.Data.EntityClient"></add> </connectionstrings>
2.Oracle:
<connectionstrings> <add name="EntityDesignEntities" connectionstring="metadata=res://*/EntityDataModel.EntityDesign.csdl|res://*/EntityDataModel.EntityDesign.ssdl|res://*/EntityDataModel.EntityDesign.msl;provider=Oracle.DataAccess.Client;provider connection string=" data source="xe;password=xxx;persist" security info="True;user" id='sa""' providername="System.Data.EntityClient"></add> </connectionstrings>
3.MySQL:
<connectionstrings> <add name="EntityDesignEntities" connectionstring="metadata=res://*/EntityDataModel.EntityDesign.csdl|res://*/EntityDataModel.EntityDesign.ssdl|res://*/EntityDataModel.EntityDesign.msl;provider=MySql.Data.MySqlClient;provider connection string=" server="localhost;user" id="sa;password=xxxx;persist" security info='True;database=world""' providername="System.Data.EntityClient"></add> </connectionstrings>