public void IsNotBlankOrNull_MissingAtSymb()
{
SearchExpression <string> expression = null;
Dictionary <string, object> parameters = null;
string whereParam = null;
expression = Expression.IsNotBlankOrNull();
parameters = expression.GetDynamicParameters("p1");
whereParam = expression.ToSqlExpression("[Table].[Field]", "p1");
Assert.IsNull(parameters["p1"]);
Assert.AreEqual(whereParam, " and nullif([Table].[Field], '') is not null");
}
public void HasValue()
{
SearchExpression <string> expression = null;
Dictionary <string, object> parameters = null;
string whereParam = null;
expression = Expression.HasValue();
parameters = expression.GetDynamicParameters("@p1");
whereParam = expression.ToSqlExpression("[Table].[Field]", "@p1");
Assert.IsNull(parameters["p1"]);
Assert.AreEqual(whereParam, " and [Table].[Field] is not null");
}
public void NotInSet_MissingAtSymb()
{
SearchExpression <string> expression = null;
Dictionary <string, object> parameters = null;
string whereParam = null;
expression = Expression.NotInSet(new[] { "a", "b" });
parameters = expression.GetDynamicParameters("p1");
whereParam = expression.ToSqlExpression("[Table].[Field]", "p1");
Assert.IsTrue(((IEnumerable <string>)parameters["p1"]).Contains("a"));
Assert.IsTrue(((IEnumerable <string>)parameters["p1"]).Contains("b"));
Assert.AreEqual(whereParam, " and [Table].[Field] not in @p1");
}
