public void Inverse_should_produce_drop_table_operation() { var createProcedureOperation = new AlterProcedureOperation("Foo", "Bar"); Assert.IsType <NotSupportedOperation>(createProcedureOperation.Inverse); }
public void Inverse_should_produce_drop_table_operation() { var createProcedureOperation = new AlterProcedureOperation("Foo", "Bar"); Assert.IsType<NotSupportedOperation>(createProcedureOperation.Inverse); }
public void Generate_can_output_alter_procedure_operations() { var alterProcedureOperation = new AlterProcedureOperation("Foo", "SELECT ShinyHead\r\nFROM Pilkingtons"); alterProcedureOperation.Parameters.Add( new ParameterModel(PrimitiveTypeKind.String) { Name = "P'", DefaultValue = "Bar", IsOutParameter = true }); var codeGenerator = new CSharpMigrationCodeGenerator(); var generatedMigration = codeGenerator.Generate( "Migration", new MigrationOperation[] { alterProcedureOperation }, "Source", "Target", "Foo", "Bar"); Assert.Equal( @"namespace Foo { using System; using System.Data.Entity.Migrations; public partial class Bar : DbMigration { public override void Up() { AlterStoredProcedure( ""Foo"", p => new { P = p.String(name: ""P'"", defaultValue: ""Bar"", outParameter: true), }, body: @""SELECT ShinyHead FROM Pilkingtons"" ); } public override void Down() { throw new NotSupportedException(""" + Strings.ScaffoldSprocInDownNotSupported + @"""); } } } ", generatedMigration.UserCode); }
public void Generate_can_output_alter_procedure_operations() { var alterProcedureOperation = new AlterProcedureOperation("Foo", "SELECT ShinyHead\r\nFROM Pilkingtons"); alterProcedureOperation.Parameters.Add( new ParameterModel(PrimitiveTypeKind.String) { Name = "P'", DefaultValue = "Bar", IsOutParameter = true }); var codeGenerator = new VisualBasicMigrationCodeGenerator(); var generatedMigration = codeGenerator.Generate( "Migration", new MigrationOperation[] { alterProcedureOperation }, "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() AlterStoredProcedure( ""Foo"", Function(p) New With { .P = p.String(name := ""P'"", defaultValue := ""Bar"", outParameter := True) }, body := ""SELECT ShinyHead"" & vbCrLf & _ ""FROM Pilkingtons"" ) End Sub Public Overrides Sub Down() Throw New NotSupportedException(""" + Strings.ScaffoldSprocInDownNotSupported + @""") End Sub End Class End Namespace ", generatedMigration.UserCode); }
public void Can_add_and_enumerate_parameters() { var createProcedureOperation = new AlterProcedureOperation("Foo", "Bar"); createProcedureOperation.Parameters.Add( new ParameterModel(PrimitiveTypeKind.Int64) { Name = "Bar" }); Assert.NotNull(createProcedureOperation.Parameters.Single()); }
public void Can_add_and_enumerate_parameters() { var createProcedureOperation = new AlterProcedureOperation("Foo", "Bar"); createProcedureOperation.Parameters.Add( new ParameterModel(PrimitiveTypeKind.Int64) { Name = "Bar" }); Assert.NotNull(createProcedureOperation.Parameters.Single()); }
protected virtual IEnumerable<MigrationStatement> Generate(AlterProcedureOperation operation) { return Generate(operation, "ALTER"); }
/// <summary>Generates code to perform a <see cref="T:System.Data.Entity.Migrations.Model.AlterProcedureOperation" />.</summary> /// <param name="alterProcedureOperation">The operation to generate code for.</param> /// <param name="writer">Text writer to add the generated code to.</param> protected virtual void Generate(AlterProcedureOperation alterProcedureOperation, IndentedTextWriter writer) { Check.NotNull(alterProcedureOperation, "alterProcedureOperation"); Check.NotNull(writer, "writer"); Generate(alterProcedureOperation, "AlterStoredProcedure", writer); }
/// <summary> /// Generates the specified alter procedure operation. /// </summary> /// <param name="alterProcedureOperation">The alter procedure operation.</param> protected virtual void Generate(AlterProcedureOperation alterProcedureOperation) { Check.NotNull(alterProcedureOperation, "alterProcedureOperation"); Generate(alterProcedureOperation, "ALTER"); }
/// <summary> /// Generates the specified alter procedure operation. /// </summary> /// <param name="alterProcedureOperation">The alter procedure operation.</param> protected virtual void Generate(AlterProcedureOperation alterProcedureOperation) { }