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; }