What is the best way to write a stored procedure with FluentMigrator

457 Views Asked by At
[Migration(1)]
public class TestCreateUserTable : Migration
{
    public override void Up()
    {
        Execute.Script("myscriptUP.sql");
        Execute.EmbeddedScript("myscriptUP.sql");
        Execute.Sql("CREATE TABLE Users");
    }

    public override void Down()
    {
        Execute.Script("myscriptDOWN.sql");
        Execute.EmbeddedScript("myscriptDOWN.sql");
        Execute.Sql("DELETE TABLE Users");
    }
}

myscriptUP.sql

"CREATE TABLE Users"

myscriptDOWN.sql

"DELETE TABLE Users"

when I can use Script, EmbeddedScript or SQL?

0

There are 0 best solutions below