public void Can_get_and_set_rename_properties() { var renameProcedureOperation = new RenameProcedureOperation("N", "N'"); Assert.Equal("N", renameProcedureOperation.Name); Assert.Equal("N'", renameProcedureOperation.NewName); }
public void Inverse_should_produce_rename_procedure_operation() { var renameProcedureOperation = new RenameProcedureOperation("dbo.Foo", "dbo.Bar"); var inverse = (RenameProcedureOperation)renameProcedureOperation.Inverse; Assert.Equal("dbo.Bar", inverse.Name); Assert.Equal("Foo", inverse.NewName); renameProcedureOperation = new RenameProcedureOperation("dbo.Foo", "Bar"); inverse = (RenameProcedureOperation)renameProcedureOperation.Inverse; Assert.Equal("dbo.Bar", inverse.Name); Assert.Equal("Foo", inverse.NewName); renameProcedureOperation = new RenameProcedureOperation("Foo", "Bar"); inverse = (RenameProcedureOperation)renameProcedureOperation.Inverse; Assert.Equal("Bar", inverse.Name); Assert.Equal("Foo", inverse.NewName); }
protected virtual IEnumerable<MigrationStatement> Generate(RenameProcedureOperation operation) { throw new NotSupportedException("'RenameProcedureOperation' is not supported."); }
/// <summary> /// Generates code to perform a <see cref="RenameProcedureOperation" />. /// </summary> /// <param name="renameProcedureOperation">The operation to generate code for.</param> /// <param name="writer">Text writer to add the generated code to.</param> protected virtual void Generate(RenameProcedureOperation renameProcedureOperation, IndentedTextWriter writer) { Check.NotNull(renameProcedureOperation, "renameProcedureOperation"); Check.NotNull(writer, "writer"); writer.Write("RenameStoredProcedure(name := "); writer.Write(Quote(renameProcedureOperation.Name)); writer.Write(", newName := "); writer.Write(Quote(renameProcedureOperation.NewName)); writer.WriteLine(")"); }
/// <summary> /// Generates the specified rename procedure operation. /// </summary> /// <param name="renameProcedureOperation">The rename procedure operation.</param> protected virtual void Generate(RenameProcedureOperation renameProcedureOperation) { Check.NotNull(renameProcedureOperation, "renameProcedureOperation"); using (var writer = Writer()) { writer.Write("EXECUTE sp_rename @objname = N'"); writer.Write(Escape(renameProcedureOperation.Name)); writer.Write("', @newname = N'"); writer.Write(Escape(renameProcedureOperation.NewName)); writer.Write("', @objtype = N'OBJECT'"); Statement(writer); } }
/// <summary> /// Generates the specified rename procedure operation. /// </summary> /// <param name="renameProcedureOperation">The rename procedure operation.</param> protected virtual void Generate(RenameProcedureOperation renameProcedureOperation) { }
public void Generate_can_output_rename_procedure_operation() { var renameProcedureOperation = new RenameProcedureOperation("Foo", "Bar"); var codeGenerator = new CSharpMigrationCodeGenerator(); var generatedMigration = codeGenerator.Generate( "Migration", new MigrationOperation[] { renameProcedureOperation }, "Source", "Target", "Foo", "Bar"); Assert.Equal( @"namespace Foo { using System; using System.Data.Entity.Migrations; public partial class Bar : DbMigration { public override void Up() { RenameStoredProcedure(name: ""Foo"", newName: ""Bar""); } public override void Down() { RenameStoredProcedure(name: ""Bar"", newName: ""Foo""); } } } ", generatedMigration.UserCode); }
public void Generate_can_output_rename_procedure_operation() { var renameProcedureOperation = new RenameProcedureOperation("Foo", "Bar"); var codeGenerator = new VisualBasicMigrationCodeGenerator(); var generatedMigration = codeGenerator.Generate( "Migration", new MigrationOperation[] { renameProcedureOperation }, "Source", "Target", "Foo", "Bar"); Assert.Equal( @"Imports System Imports System.Data.Entity.Migrations Imports Microsoft.VisualBasic Namespace Foo Public Partial Class Bar Inherits DbMigration Public Overrides Sub Up() RenameStoredProcedure(name := ""Foo"", newName := ""Bar"") End Sub Public Overrides Sub Down() RenameStoredProcedure(name := ""Bar"", newName := ""Foo"") End Sub End Class End Namespace ", generatedMigration.UserCode); }