public void CreateProcedureWithNVarCharNoSizeParameter() { procedure.Parameters.AddString(StringColumnName, SqlDbType.NVarChar).Direction = ParameterDirection.Input; string expected = $"create procedure {ProcedureName} {StringColumnName} NVarChar(1) as begin {ProcedureBody} end"; string actual = new ProcedureCreateSqlGenerator().Sql(procedure); Assert.AreEqual(expected, actual); }
public void CreateProcedureWithMaxSizeNVarCharParameter() { var parameter = procedure.Parameters.AddString(StringColumnName, SqlDbType.NVarChar); parameter.Direction = ParameterDirection.Input; parameter.IsMaximumSize = true; string expected = $"create procedure {ProcedureName} {StringColumnName} NVarChar(max) as begin {ProcedureBody} end"; string actual = new ProcedureCreateSqlGenerator().Sql(procedure); Assert.AreEqual(expected, actual); }
public void CreateProcedureWithDecimalParameter() { var parameter = procedure.Parameters.AddDecimal("money"); parameter.Direction = ParameterDirection.Input; parameter.Precision = 10; parameter.Scale = 5; string expected = $"create procedure {ProcedureName} @money Decimal(10,5) as begin {ProcedureBody} end"; string actual = new ProcedureCreateSqlGenerator().Sql(procedure); Assert.AreEqual(expected, actual); }
public void CreateProcedureWithSingleParameter() { procedure.Parameters.AddInteger(IntegerColumnName, SqlDbType.Int).Direction = ParameterDirection.Input; string expected = $"create procedure {ProcedureName} {IntegerColumnName} Int as begin {ProcedureBody} end"; string actual = new ProcedureCreateSqlGenerator().Sql(procedure); Assert.AreEqual(expected, actual); }