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

Post a reply

Smilies
:) :( :oops: :chelo: :roll: :wink: :muza: :sorry: :angel: :read: *x) :clever:
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Was ist der beste Weg, eine gespeicherte Prozedur mit FluentMigrator zu schreiben?

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

Code: Select all

"CREATE TABLE Users"
myscriptDOWN.sql

Code: Select all

"DELETE TABLE Users"
Wann kann ich Script, EmbeddedScript oder SQL verwenden?

Top