public void ShouldWriteQueryForUpdateStoredProcedure() { var op = new UpdateStoredProcedureOperation(SchemaName, ProcedureName, Definition); const string expectedQuery = "alter procedure [schemaName].[procedureName] as definition"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldSetPropertiesForUpdateStoredProcedure() { var op = new UpdateStoredProcedureOperation(SchemaName, ProcedureName, Definition); Assert.AreEqual(SchemaName, op.SchemaName); Assert.AreEqual(ProcedureName, op.Name); Assert.AreEqual(Definition, op.Definition); Assert.That(op.ObjectName, Is.EqualTo(string.Format("{0}.{1}", SchemaName, ProcedureName))); }