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