.net code first 改为mysql数据库的步骤

1.所有工程追加Mysql.data的引用

2.WEB工程中的web.config中追加mysql的provider

<provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"></provider>

3.WEB工程中的web.config中修改connection string

<add name="Default" connectionString="data source=[ip地址];port=3306;initial catalog=[数据库名];user id=[用户名]; password=[密码];Charset=utf8;Convert Zero Datetime=True;Allow Zero Datetime=True" providerName="MySql.Data.MySqlClient" />

4.EntityFrame工程中的Configuration.cs修改

    public sealed class Configuration : DbMigrationsConfiguration<[应用名].EntityFramework.OmsDbContext>, IMultiTenantSeed
    {
        public AbpTenantBase Tenant { get; set; }

        public Configuration()
        {
            AutomaticMigrationsEnabled = false;
            ContextKey = "[应用名]";
            // register mysql code generator
            SetSqlGenerator("MySql.Data.MySqlClient", new MySql.Data.Entity.MySqlMigrationSqlGenerator());
        }

5.EntityFrame工程中的[应用名]DbContext.cs修改[

    [DbConfigurationType(typeof(MySqlEFConfiguration))]
    public class [应用名]DbContext : AbpZeroDbContext<Tenant, Role, User>
    {
        //TODO: Define an IDbSet for your Entities...
        #region "IDbSets"

补充
二进制类型Mysql需要在实体的属性中加上下面特性，但是SQLSERVER坚决不能加，否则就会生成错误“序列不包含任何匹配元素”
[Column(TypeName = “blob”)]