search

Home  >  Article  >  Database  >  EntityFramework在不同数据库下的配置

EntityFramework在不同数据库下的配置

WBOY
WBOYOriginal
2016-06-07 15:24:121239browse

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>


 

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：蛋白质乙酰化数据库 CPLA 1.0Next article：数据库管理员岗位职责

Related articles

See more