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()); }