public IPredicateExpression IsNull()
{
Comparison = ConstraintComparison.Is;
ParameterValue = DBNull.Value;
return predicateExpression;
}
internal static string GetComparisonOperator(ConstraintComparison comp)
{
string sOut;
switch (comp)
{
case ConstraintComparison.GreaterThan:
sOut = SqlComparison.GREATER;
break;
case ConstraintComparison.GreaterOrEquals:
sOut = SqlComparison.GREATER_OR_EQUAL;
break;
case ConstraintComparison.LessThan:
sOut = SqlComparison.LESS;
break;
case ConstraintComparison.LessOrEquals:
sOut = SqlComparison.LESS_OR_EQUAL;
break;
case ConstraintComparison.Like:
sOut = SqlComparison.LIKE;
break;
case ConstraintComparison.NotEquals:
sOut = SqlComparison.NOT_EQUAL;
break;
case ConstraintComparison.NotLike:
sOut = SqlComparison.NOT_LIKE;
break;
case ConstraintComparison.Is:
sOut = SqlComparison.IS;
break;
case ConstraintComparison.IsNot:
sOut = SqlComparison.IS_NOT;
break;
case ConstraintComparison.In:
sOut = " IN ";
break;
case ConstraintComparison.NotIn:
sOut = " NOT IN ";
break;
default:
sOut = SqlComparison.EQUAL;
break;
}
return sOut;
}
public IPredicateExpression IsNotLike(string value)
{
Comparison = ConstraintComparison.NotLike;
ParameterValue = value;
return predicateExpression;
}
public IPredicateExpression IsNotIn(IEnumerable values)
{
InValues = values;
Comparison = ConstraintComparison.NotIn;
return predicateExpression;
}
public IPredicateExpression IsNotEqualTo(object value)
{
Comparison = ConstraintComparison.NotEquals;
ParameterValue = value;
return predicateExpression;
}
public IPredicateExpression IsLessThan(object value)
{
Comparison = ConstraintComparison.LessThan;
ParameterValue = value;
return predicateExpression;
}
public IPredicateExpression IsBetweenAnd(object value1, object value2)
{
Comparison = ConstraintComparison.Between;
StartValue = value1;
EndValue = value2;
return predicateExpression;
}
