public override void Generate(CreateSchemaOperation operation, IModel model, SqlBatchBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
throw new NotImplementedException();
}
public static OperationBuilderSurface <CreateSchemaOperation> CreateSchema(this IMigrationBuilder builder, string schema, string catalog = null)
{
var op = new CreateSchemaOperation
{
Name = new ObjectName(catalog, schema, null)
};
builder.AddOperation(op);
return(new OperationBuilderSurface <CreateSchemaOperation>(op));
}
public virtual void Generate(
[NotNull] CreateSchemaOperation operation,
[CanBeNull] IModel model,
[NotNull] SqlBatchBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
builder
.Append("CREATE SCHEMA ")
.Append(_sql.DelimitIdentifier(operation.Name));
}
public virtual OperationBuilder <CreateSchemaOperation> CreateSchema(
[NotNull] string name)
{
Check.NotEmpty(name, nameof(name));
var operation = new CreateSchemaOperation
{
Name = name
};
Operations.Add(operation);
return(new OperationBuilder <CreateSchemaOperation>(operation));
}
protected virtual void Generate([NotNull] CreateSchemaOperation operation, [NotNull] IndentedStringBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
builder
.Append(".CreateSchema(")
.Append(_code.Literal(operation.Name))
.Append(")");
using (builder.Indent())
{
Annotations(operation.Annotations, builder);
}
}
public override void Generate(CreateSchemaOperation operation, IModel model, SqlBatchBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
if (string.Equals(operation.Name, "DBO", StringComparison.OrdinalIgnoreCase))
{
return;
}
builder
.Append("IF SCHEMA_ID(N")
.Append(_sql.GenerateLiteral(operation.Name))
.Append(") IS NULL EXEC(N'CREATE SCHEMA ")
.Append(_sql.DelimitIdentifier(operation.Name))
.Append("')");
}
public abstract void Generate(
[NotNull] CreateSchemaOperation operation,
[CanBeNull] IModel model,
[NotNull] SqlBatchBuilder builder);
public override void Generate(CreateSchemaOperation operation, IModel model, SqlBatchBuilder builder)
{
throw new NotSupportedException(Strings.SchemasNotSupported);
}
public override void Generate(CreateSchemaOperation operation, IModel model, SqlBatchBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
if (string.Equals(operation.Name, "DBO", StringComparison.OrdinalIgnoreCase))
{
return;
}
builder
.Append("IF SCHEMA_ID(N")
.Append(_sql.GenerateLiteral(operation.Name))
.Append(") IS NULL EXEC(N'CREATE SCHEMA ")
.Append(_sql.DelimitIdentifier(operation.Name))
.Append("')");
}
public override void Generate(CreateSchemaOperation operation, IModel model, SqlBatchBuilder builder)
{
throw new NotSupportedException(Strings.SchemasNotSupported);
}
