public BinaryWhereParameter(string fieldName, BinarySqlOperand operand, Parameter firstParameter, Parameter secondParameter) { this.firstParameter = firstParameter; this.secondParameter = secondParameter; FieldName = fieldName; Operand = operand; }
public BinaryWhereClause(IWhereFieldReference whereFieldReference, BinarySqlOperand operand, string firstParameterName, string secondParameterName) { this.whereFieldReference = whereFieldReference; this.operand = operand; this.firstParameterName = firstParameterName; this.secondParameterName = secondParameterName; }
public IBinaryParametersDeleteQueryBuilder <TRecord> WhereParameterised(string fieldName, BinarySqlOperand operand, Parameter startValueParameter, Parameter endValueParameter) { var uniqueStartParameter = new UniqueParameter(uniqueParameterNameGenerator, startValueParameter); var uniqueEndParameter = new UniqueParameter(uniqueParameterNameGenerator, endValueParameter); return(new BinaryParametersDeleteQueryBuilder <TRecord>( AddWhereClause(new BinaryWhereClause(new WhereFieldReference(fieldName), operand, uniqueStartParameter.ParameterName, uniqueEndParameter.ParameterName)), uniqueStartParameter, uniqueEndParameter)); }
/// <summary> /// Adds a binary where expression to the query. /// </summary> /// <typeparam name="TRecord">The record type of the query builder</typeparam> /// <param name="queryBuilder">The query builder</param> /// <param name="fieldName">The name of one of the columns in the query. The where condition will be evaluated against the value of this column.</param> /// <param name="operand">The SQL operator to be used in the where clause</param> /// <param name="startValue">The first or starting value to be used to compare against the column values in the where clause. It will be added to the query as a parameter.</param> /// <param name="endValue">The second or ending value to be used to compare against the column values in the where clause. It will be added to the query as a parameter.</param> /// <returns>The query builder that can be used to further modify the query, or execute the query</returns> public static IQueryBuilder <TRecord> Where <TRecord>(this IQueryBuilder <TRecord> queryBuilder, string fieldName, BinarySqlOperand operand, object startValue, object endValue) where TRecord : class { return(queryBuilder.WhereParameterised(fieldName, operand, new Parameter("StartValue"), new Parameter("EndValue")) .ParameterValues(startValue, endValue)); }
public IBinaryParametersQueryBuilder <TRecord> WhereParameterised(string fieldName, BinarySqlOperand operand, Parameter startValueParameter, Parameter endValueParameter) { var uniqueStartParameter = new UniqueParameter(uniqueParameterNameGenerator, startValueParameter); var uniqueEndParameter = new UniqueParameter(uniqueParameterNameGenerator, endValueParameter); selectBuilder.AddWhere(new BinaryWhereParameter(fieldName, operand, uniqueStartParameter, uniqueEndParameter)); return(new BinaryParametersQueryBuilder <TRecord>(Parameter(uniqueStartParameter).Parameter(uniqueEndParameter), uniqueStartParameter, uniqueEndParameter)); }
public IBinaryParametersQueryBuilder <TRecord> WhereParameterised(string fieldName, BinarySqlOperand operand, Parameter startValueParameter, Parameter endValueParameter) { return(Builder.WhereParameterised(fieldName, operand, startValueParameter, endValueParameter)); }