public static WhereClip operator <=(object left, ExpressionClip right) { WhereClip where = new WhereClip(); if (left == null || left == DBNull.Value) { where = ExpressionFactory.AppendWhereAnd(where, right, QueryOperator.GreaterOrEqual, null); } else { ExpressionFactory.AppendWhereAnd(where, ExpressionFactory.CreateParameterExpression(right.DbType, left), QueryOperator.LessOrEqual, right); } return(where); }
public static WhereClip operator >=(ExpressionClip left, object right) { WhereClip where = new WhereClip(); if (right == null || right == DBNull.Value) { ExpressionFactory.AppendWhereAnd(where, left, QueryOperator.GreaterOrEqual, null); } else { ExpressionFactory.AppendWhereAnd(where, left, QueryOperator.GreaterOrEqual, ExpressionFactory.CreateParameterExpression(left.DbType, right)); } return(where); }
public static WhereClip operator <=(ExpressionClip left, ExpressionClip right) { WhereClip where = new WhereClip(); if (ExpressionClip.IsNullOrEmpty(right)) { where = ExpressionFactory.AppendWhereAnd(where, left, QueryOperator.LessOrEqual, null); } else if (ExpressionClip.IsNullOrEmpty(left)) { where = ExpressionFactory.AppendWhereAnd(where, right, QueryOperator.GreaterOrEqual, null); } else { ExpressionFactory.AppendWhereAnd(where, left, QueryOperator.LessOrEqual, right); } return(where); }
public WhereClip EndsWith(string suffix) { Check.Require(!string.IsNullOrEmpty(suffix), "suffix could not be null or empty!"); return(ExpressionFactory.AppendWhereAnd(new WhereClip(), this, QueryOperator.Like, ExpressionFactory.CreateParameterExpression(this.dbType, '%' + suffix.Replace("%", "[%]").Replace("_", "[_]")))); }
public WhereClip Like(string right) { Check.Require(right != null, "right could not be null."); return(ExpressionFactory.AppendWhereAnd(new WhereClip(), this, Rock.Orm.Common.QueryOperator.Like, ExpressionFactory.CreateParameterExpression(this.DbType, right))); }