by Guest » 11 Jan 2025, 12:33
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
myscriptDOWN.sql
Wann kann ich Script, EmbeddedScript oder SQL verwenden?
[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?