Programmiererforum

[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");
}
}

"CREATE TABLE Users"

"DELETE TABLE Users"

[code][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");
}
}
[/code]
myscriptUP.sql
[code]"CREATE TABLE Users"
[/code]
myscriptDOWN.sql
[code]"DELETE TABLE Users"
[/code]
Wann kann ich Script, EmbeddedScript oder SQL verwenden?