ef mysql注释_EFCore CodeFirst模型迁移生成数据库备注（mysql）

重写Mysql下sql脚本生成器

using Framework.NetCore.Extensions;

using Framework.NetCore.Models;

using Microsoft.EntityFrameworkCore.Metadata;

using Microsoft.EntityFrameworkCore.Migrations;

using Microsoft.EntityFrameworkCore.Migrations.Operations;

using Pomelo.EntityFrameworkCore.MySql.Infrastructure.Internal;

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Reflection;

using System.Text;

namespace Framework.NetCore.EfDbContext

{

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);

}

///

/// Create table comment.

///

///

///

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

{

string tableName = string.Empty;

string description = string.Empty;

if (operation is AlterTableOperation)