/// <summary>
/// Verifies the existence of targeted schema. If schema is not verified, will check for the existence of the dbo schema.
/// </summary>
public void VerifySchema()
{
var sqlRunner = new AdHocSqlRunner(connectionFactory, schema);
sqlRunner.ExecuteNonQuery(string.Format(
@"IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'{0}') Exec('CREATE SCHEMA {0}')", schema));
}
/// <summary>
/// Verifies the existence of targeted schema. If schema is not verified, will check for the existence of the dbo schema.
/// </summary>
public void VerifySchema()
{
if (string.IsNullOrEmpty(Schema)) return;
connectionManager().ExecuteCommandsWithManagedConnection(dbCommandFactory =>
{
var sqlRunner = new AdHocSqlRunner(dbCommandFactory, Schema, () => true);
sqlRunner.ExecuteNonQuery(string.Format(
@"IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'{0}') Exec('CREATE SCHEMA [{0}]')", Schema));
});
}
/// <summary>
/// Verifies the existence of targeted schema. If schema is not verified, will check for the existence of the dbo schema.
/// </summary>
public void VerifySchema()
{
if (string.IsNullOrEmpty(Schema)) return;
var sqlRunner = new AdHocSqlRunner(connectionFactory, Schema, () => true);
sqlRunner.ExecuteNonQuery(string.Format(
@"IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'{0}') Exec('CREATE SCHEMA {0}')", Schema));
}