public void SetName_WithNullValue_ThrowsArgumentNullException()
{
// ARRANGE
var parameters = new ScalarValueFunctionWithParameterAndReturn.Parameter();
var function = new ScalarValueFunctionWithParameterAndReturn(parameters);
// ACT
function.SetFunctionName(null);
// ASSERT
Assert.Fail("ArgumentOutOfRangeException not encountered");
}
public void ScalarValueFunctionWithParameterAndReturn_ReturnsCorrectValue()
{
// ARRANGE
const int expectedValue = 100;
var parameters = new ScalarValueFunctionWithParameterAndReturn.Parameter
{
Value1 = expectedValue
};
var function = new ScalarValueFunctionWithParameterAndReturn(parameters);
// ACT
var results = Connection.ExecuteSqlScalarFunction(function);
// ASSERT
Assert.IsNotNull(results);
Assert.AreEqual(expectedValue, results);
}
public void GetTwoPartName_WhenConstructedWithProcedureName_ReturnsCorrectly()
{
// ARRANGE
const string expectedSchemaName = StoredProcedureDefaults.DefaultSchemaName;
const string expectedProcedureName = "GetAllMonkeys";
string expectedTwoPartName = String.Concat(
expectedSchemaName,
StoredProcedureDefaults.DotIdentifier,
expectedProcedureName);
var parameters = new ScalarValueFunctionWithParameterAndReturn.Parameter();
var procedure = new ScalarValueFunctionWithParameterAndReturn(expectedProcedureName, parameters);
// ACT
var actualTwoPartName = procedure.GetTwoPartName();
// ASSERT
Assert.AreEqual(expectedTwoPartName, actualTwoPartName);
}
public void SetName_WithValidValue_CheckNameProperty_ReturnsCorrect()
{
// ARRANGE
const string expectedValue = "TestName";
var parameters = new ScalarValueFunctionWithParameterAndReturn.Parameter();
var function = new ScalarValueFunctionWithParameterAndReturn(parameters);
// ACT
function.SetFunctionName(expectedValue);
var actualValue = function.FunctionName;
// ASSERT
Assert.AreEqual(expectedValue, actualValue);
}
public void SetSchema_WithInvalidValue_ThrowsArgumentOutOfRangeException()
{
// ARRANGE
var parameters = new ScalarValueFunctionWithParameterAndReturn.Parameter();
var function = new ScalarValueFunctionWithParameterAndReturn(parameters);
// ACT
function.SetSchemaName(string.Empty);
// ASSERT
Assert.Fail("ArgumentOutOfRangeException not encountered");
}
