EntityFramework在不同数据库下的配置

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>