code first 迁移 MySQL

对数据库的要求为MySQL5.7 

装mysql的.net的驱动mysql-connector-net 

  <connectionStrings>
  
    <add name="DefaultHcsy" connectionString="http://xxx.xx.xx.xxx/"/>
   
    <add name="DefaultConnection" connectionString="Data Source=xxx.xx.xx.xxx;port=xxxx;;User Id=xxx;password=xxx;database=xxx;" providerName="MySql.Data.MySqlClient" />
  </connectionStrings>

<entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6">
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>
      
       <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </providers>
  </entityFramework>

添加引用

MySql.Data.6.9.9

MySql.Data.Entity.6.9.9

Enable-Migrations -EnableAutomaticMigrations


Add-Migration InitialCreate


Update-Database -Verbose