public void CreateSchemaVersion()
{
MigrationRepository repo = new MigrationRepository(ConnectionInfo);
repo.ExecuteNonQuery("create table dbo.SchemaVersion(VersionTimestamp nvarchar(14) not null default(''))");
repo.ExecuteNonQuery("insert into dbo.SchemaVersion(VersionTimestamp)Values('')");
}
private void CreateNewDatabase(string databaseName)
{
MigrationRepository masterRepo = new MigrationRepository(MasterConnectionInfo);
masterRepo.ExecuteNonQuery("create database " + databaseName);
}
public string GetSchemaVersion()
{
MigrationRepository repo = new MigrationRepository(ConnectionInfo);
return repo.ExecuteScalar("select VersionTimestamp from dbo.SchemaVersion").ToString();
}
public void ExecuteMigrtionScript(string migrationAndSchemaVersionUpdateScript)
{
MigrationRepository repo = new MigrationRepository(ConnectionInfo);
repo.ExecuteNonQuery(migrationAndSchemaVersionUpdateScript);
}