EF6+MySql code first

1  安装必要的开发包

     MySQL For Visual Studio 和  Connector/NET

2  Nuget安装MySQL库： Install-Package MySql.Data.Entity -Version 6.9.8

    安装完毕后，项目中的引用自动添加EntityFramework、MySql.Data、MySql.data.Entity.EF6 三个程序集

3 编辑app.config配置文件

<?xml version="1.0" encoding="utf-8"?> <configuration>   <configSections>     <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->     <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />   </configSections>   <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, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />     </DbProviderFactories>   </system.data>   <entityFramework  >     <defaultConnectionFactory type="MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity.EF6"/>      <providers>       <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />     </providers>   </entityFramework>

  <connectionStrings>     <add name="MyContext" connectionString="Data Source=120.77.46.150; Initial Catalog=beikeda_da;user id=keedb;password=1234;" providerName="MySql.Data.MySqlClient"/>   </connectionStrings> </configuration>

4  修改 myDbContext类文件，增加属性 [DbConfigurationType(typeof(MySql.Data.Entity.MySqlEFConfiguration))]

5 数据库迁移：参考

            Database.SetInitializer(new MigrateDatabaseToLatestVersion<makerdb, Configuration<makerdb>>());             Database.SetInitializer(new CreateDatabaseIfNotExists<makerdb>());             Database.SetInitializer<makerdb>(null);

   internal sealed class Configuration<TContext> : DbMigrationsConfiguration<TContext> where TContext : DbContext     {         public Configuration()         {             AutomaticMigrationsEnabled = true  ;             AutomaticMigrationDataLossAllowed = true;             // register mysql code generator             SetSqlGenerator("MySql.Data.MySqlClient", new MySql.Data.Entity.MySqlMigrationSqlGenerator());

        }     }