protected virtual void Generate(DropProcedureOperation dropProcedureOperation, IndentedTextWriter writer)
{
Check.NotNull(dropProcedureOperation, "dropProcedureOperation");
Check.NotNull(writer, "writer");
writer.Write("DropStoredProcedure(");
writer.Write(Quote(dropProcedureOperation.Name));
writer.WriteLine(");");
}
protected virtual IEnumerable <MigrationStatement> Generate(DropProcedureOperation operation)
{
using (var writer = SqlWriter())
{
writer.Write("DROP PROCEDURE ");
writer.Write(Quote(CheckName(ExtractName(operation.Name))));
yield return(Statement(writer));
}
}
protected virtual void Generate(DropProcedureOperation dropProcedureOperation)
{
Check.NotNull(dropProcedureOperation, "dropProcedureOperation");
using (var writer = Writer())
{
writer.Write("DROP PROCEDURE ");
writer.Write(Name(dropProcedureOperation.Name));
Statement(writer);
}
}
public void Generate_can_output_drop_procedure_statement()
{
var dropModificationFunctionsOperation
= new DropProcedureOperation("Customer_Insert");
var migrationSqlGenerator = new SqlServerMigrationSqlGenerator();
var sql
= migrationSqlGenerator
.Generate(new[] { dropModificationFunctionsOperation }, "2008")
.Join(s => s.Sql, Environment.NewLine);
Assert.Contains(
@"DROP PROCEDURE [Customer_Insert]", sql);
}
private string GenerateSqlStatementConcrete(DropProcedureOperation migrationOperation)
{
throw new NotSupportedException("Procedures are not supported by SQLite");
}
/// <summary>
/// Generates the specified drop procedure operation.
/// </summary>
/// <param name="dropProcedureOperation">The drop procedure operation.</param>
protected virtual void Generate(DropProcedureOperation dropProcedureOperation)
{
}
protected virtual void Generate(DropProcedureOperation dropProcedureOperation)
{
ArgumentUtility.CheckNotNull("dropProcedureOperation", dropProcedureOperation);
throw new NotImplementedException("DropProcedureOperation");
}
protected override void Generate(DropProcedureOperation dropProcedureOperation, IndentedTextWriter writer)
{
base.Generate(dropProcedureOperation, writer);
}
private void Generate(DropProcedureOperation dropProcedureOperation)
{
throw new NotImplementedException();
}
