public static IDeleteQueryBuilder <TRecord> Where <TRecord>(this IDeleteQueryBuilder <TRecord> queryBuilder,
string fieldName, ArraySqlOperand operand, IEnumerable values) where TRecord : class
{
var stringValues = values.OfType <object>().Select(v => v.ToString()).ToArray();
var parameters = stringValues.Select((v, i) => new Parameter($"{fieldName}{i}")).ToArray();
return(queryBuilder.WhereParameterised(fieldName, operand, parameters).ParameterValues(stringValues));
}
public static IDeleteQueryBuilder <TRecord> Where <TRecord>(this IDeleteQueryBuilder <TRecord> queryBuilder,
string fieldName, UnarySqlOperand operand, object value) where TRecord : class
{
var parameter = new Parameter(fieldName);
return(queryBuilder.WhereParameterised(fieldName, operand, parameter)
.ParameterValue(value));
}
public static IDeleteQueryBuilder <TRecord> Where <TRecord>(this IDeleteQueryBuilder <TRecord> queryBuilder,
string fieldName, BinarySqlOperand operand, object startValue, object endValue) where TRecord : class
{
var startParameter = new Parameter("StartValue");
var endParameter = new Parameter("EndValue");
return(queryBuilder.WhereParameterised(fieldName, operand, startParameter, endParameter)
.ParameterValues(startValue, endValue));
}
