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