CreateCompare() public static method

Creates a comparison WhereTerm.
A comparison term compares two expression on the basis of their values. Expressions can be of any type but their results must be of comparible types. For instance, you can not compare a database field of type 'date' and a static value of type 'int'.
public static CreateCompare ( SqlExpression expr1, SqlExpression expr2, CompareOperator op ) : WhereTerm
expr1 SqlExpression Expression on the left side of the operator
expr2 SqlExpression Expression on the right side of the operator
op CompareOperator Conditional operator to be applied on the expressions
return WhereTerm
WhereTerm Class Documentation
Esempio n. 1
0
        public void AddCompare(Enum column, Parameter parameter, CompareOperator compareOperator)
        {
            WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field(column, fromClause.BaseTable),
                                                          compareOperator == CompareOperator.Like
                                                                        ? SqlExpression.LikeExpressionParameter()
                                                                        : SqlExpression.Parameter(), compareOperator));

            Parameters.Add(parameter);
        }
Esempio n. 2
0
 public void AddCompare(string column, SqlExpression expression, CompareOperator compareOperator)
 {
     WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field(column, fromClause.BaseTable),
                                                   expression, compareOperator));
 }
Esempio n. 3
0
 public WhereTerm CreateCompare(Enum column, SqlExpression expression, CompareOperator compareOperator)
 {
     return(WhereTerm.CreateCompare(SqlExpression.Field(column, fromClause.BaseTable),
                                    expression, compareOperator));
 }