mysql数据迁移框架_abp 框架拓展mysql 迁移：增加数据库表和列备注

using HmCoreEShopBg.Domain;

using Microsoft.EntityFrameworkCore.Metadata;

using Microsoft.EntityFrameworkCore.Migrations;

using Microsoft.EntityFrameworkCore.Migrations.Operations;

using Pomelo.EntityFrameworkCore.MySql.Infrastructure.Internal;

using Pomelo.EntityFrameworkCore.MySql.Migrations;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Linq;

using System.Reflection;

namespace HmCoreEShopBg.Test

{

///

/// 拓展迁移操作：增加数据表和列备注

///

public class MyMigrationsSqlGenerator : MySqlMigrationsSqlGenerator

{

public MyMigrationsSqlGenerator(

MigrationsSqlGeneratorDependencies dependencies,

IMigrationsAnnotationProvider migrationsAnnotations,

IMySqlOptions mySqlOptions)

: base(dependencies, migrationsAnnotations, mySqlOptions)

{

}

protected override void Generate(MigrationOperation operation, IModel model, MigrationCommandListBuilder builder)

{

base.Generate(operation, model, builder);

if (operation is CreateTableOperation || operation is AlterTableOperation)

CreateTableComment(operation, model, builder);

if (operation is AddColumnOperation || operation is AlterColumnOperation)

CreateColumnComment(operation, model, builder);

}

///

/// 创建表注释

///

///

///

private void CreateTableComment(MigrationOperation operation, IModel model, MigrationCommandListBuilder builder)

{

string tableName = string.Empty;

string description = string.Empty;

if (operation is AlterTableOperation)

{

var t = operation as AlterColumnOperation;

tableName = (opera