Run Entity Framework Migrations using External SQL Files

pellerex-run-entity-framework-migration-using-external-sql-file.cs

public partial class FullAddressFullTextIndex : Migration
{
    protected override void Up(MigrationBuilder migrationBuilder)
    {
        string sql = GeneralFunctions.ReadSql(typeof(FullAddressFullTextIndex), "20220702124309_FullAddressFullTextIndex.sql");
        migrationBuilder.Sql(sql, true);
    }

    protected override void Down(MigrationBuilder migrationBuilder)
    {
        string sql = GeneralFunctions.ReadSql(typeof(FullAddressFullTextIndex), "20220702124309_FullAddressFullTextIndexUndo.sql");
        migrationBuilder.Sql(sql, true);
    }
}