Was ist der beste Weg, eine gespeicherte Prozedur mit FluentMigrator zu schreiben? ⇐ C#

[Guest]

Code: Select all

[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

Code: Select all

"CREATE TABLE Users"

myscriptDOWN.sql

Code: Select all

"DELETE TABLE Users"

Wann kann ich Script, EmbeddedScript oder SQL verwenden?