public void SqlQueryParameterExtensions_EmptyArray_ReturnEmptyArray()
{
SqlQueryParameter[] array = new SqlQueryParameter[0];
SqlParameter[] result = array.ToSqlParameters();
Assert.IsNotNull(result);
Assert.AreEqual(0, result.Length);
}
public void SqlQueryParameterExtensions_ArrayWithNull_ReturnDBNull()
{
SqlQueryParameter[] array = new SqlQueryParameter[]
{
new SqlQueryParameter("ColumnA", null)
};
SqlParameter[] result = array.ToSqlParameters();
Assert.IsNotNull(result);
Assert.AreEqual(1, result.Length);
Assert.AreEqual("@ColumnA", result[0].ParameterName);
Assert.AreEqual(DBNull.Value, result[0].Value);
}
public void SqlQueryParameterExtensions_ArrayWithResolver_CallResolverAndReturnResult()
{
Func <int> resolveAction = () => 123;
SqlQueryParameter[] array = new SqlQueryParameter[]
{
new SqlQueryParameter("ColumnA", new Resolver <int>(resolveAction))
};
SqlParameter[] result = array.ToSqlParameters();
Assert.IsNotNull(result);
Assert.AreEqual(1, result.Length);
Assert.AreEqual("@ColumnA", result[0].ParameterName);
Assert.AreEqual(123, result[0].Value);
}
public void SqlQueryParameterExtensions_ArrayWithMultipleRequiredPlaceholder_ThrowFirstError()
{
SqlQueryParameter[] array = new SqlQueryParameter[]
{
new SqlQueryParameter("ColumnA", Placeholders.IsRequired()),
new SqlQueryParameter("ColumnB", Placeholders.IsRequired())
};
RequiredPlaceholderIsNullException exception = Assert.Throws <RequiredPlaceholderIsNullException>(() => array.ToSqlParameters());
Assert.AreEqual("ColumnA", exception.ColumnName);
Assert.AreEqual("The value for ColumnA is required but has not been set", exception.Message);
}
