public bool Exists(MigratorDatabase migratorDatabase)
{
return(0 != migratorDatabase.SqlQuery <int>($@"
SELECT Count(*) FROM sys.tables AS tables
JOIN sys.schemas AS schemas on tables.schema_id = schemas.schema_id
WHERE concat(schemas.name, '.', tables.name) = '{TableName}' AND type = 'U'").Single());
}
private void CreateSchemaIfNotExisting(MigratorDatabase migratorDatabase)
{
var schemaCount = migratorDatabase.SqlQuery <int>($@"
SELECT Count(schema_name)
FROM information_schema.schemata
WHERE schema_name = '{SchemaName}'").Single();
if (schemaCount == 1)
{
return;
}
try
{
migratorDatabase.ExecuteSqlCommand($"CREATE SCHEMA {SchemaName}");
}
catch (SqlException e) when(e.Number == ThereIsAlreadyAnObjectNamedXXXXInTheDatabase)
{
}
}
public long GetCurrentVersionWithLock(MigratorDatabase migratorDatabase)
{
return(migratorDatabase.SqlQuery <long>(CurrentVersionQuery + " WITH (UPDLOCK, TABLOCK)", SecondsToWaitOnFetchingTheDatabaseVersion).FirstOrDefault());
}
public long GetCurrentVersion(MigratorDatabase migratorDatabase)
{
return(migratorDatabase.SqlQuery <long>(CurrentVersionQuery, SecondsToWaitOnFetchingTheDatabaseVersion).FirstOrDefault());
}