EntityFramework在不同数据库下的配置

最新推荐文章于 2018-09-21 04:03:40 发布

weiky626

最新推荐文章于 2018-09-21 04:03:40 发布

阅读量9k

点赞数 1

分类专栏：业务基础平台

本文链接：https://blog.csdn.net/weiky626/article/details/17068593

版权

业务基础平台专栏收录该内容

10 篇文章 0 订阅

订阅专栏

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" />
  </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"/>
  </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"/>
  </connectionStrings>