EF 配置（SqlServer，Mysql）

DbProvider

Mysql

<system.data>
<DbProviderFactories>
<remove invariant="MySql.Data.MySqlClient"/>
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" 
    type="MySql.Data.MySqlClient.MySqlClientFactory,MySql.Data"/>
</DbProviderFactories>
</system.data>

Connection String

Sqlserver

<connectionStrings>
    <add name="ConnectionStringName" 
connectionString="Data Source=.;Initial Catalog=xxxx;Persist Security Info=True;User ID=xx;Password=xxx;Connect Timeout=120;" 
providerName="System.Data.SqlClient" />
  </connectionStrings>

<connectionStrings>
<add name="ConnectionStringName" connectionString="Datasource=hostname;Database=schema_name;uid=username;pwd=Pa$$w0rd;" 
    providerName="MySql.Data.MySqlClient"/>
</connectionStrings>

Database Initializer

<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, 
EntityFramework, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="Server=localhost; Database=ActivitySpread_Dev; User Id=zxx;Password=xxx; 
Integrated Security=False; MultipleActiveResultSets=True;" />      
</parameters>
    </defaultConnectionFactory>
  </entityFramework>

<configSections><section name="entityFramework" 
    type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, 
    EntityFramework, Version=5.0.0.0, Culture=neutral, 
    PublicKeyToken=b77a5c561934e089"/></configSections><entityFramework><contexts><context type="Namespace.YourContextName, AssemblyName"><databaseInitializer 
           type="Namespace.YourChosenInitializer, AssemblyName"></databaseInitializer></context></contexts><defaultConnectionFactory 
      type="MySql.Data.MySqlClient.MySqlClientFactory,MySql.Data"/></entityFramework>

如果覺得本文适合您且對您有幫助，請一定記得點推薦喲！

EF 配置（SqlServer，Mysql）

作者：

JasNature

出處：

http://NatureSex.cnblogs.com

本文版權歸作者和部落格園共有，歡迎轉載，但必須保留此段聲明，且在文章頁面明顯位置給出原文連接配接。

如果本文有什麼不妥或者錯誤的地方，請您一定要在評論中指出，以免誤人子弟！非常感謝您的不吝賜教！