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, 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, 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));
}
public BinaryParametersDeleteQueryBuilder(IDeleteQueryBuilder <TRecord> deleteQueryBuilder, UniqueParameter startParameter, UniqueParameter endParameter)
{
this.deleteQueryBuilder = deleteQueryBuilder;
this.startParameter = startParameter;
this.endParameter = endParameter;
}
public UnaryParameterDeleteQueryBuilder(IDeleteQueryBuilder <TRecord> deleteQueryBuilder, UniqueParameter parameter)
{
this.deleteQueryBuilder = deleteQueryBuilder;
this.parameter = parameter;
}
public ArrayParametersDeleteQueryBuilder(IDeleteQueryBuilder <TRecord> deleteQueryBuilder, IReadOnlyList <UniqueParameter> parameters)
{
this.deleteQueryBuilder = deleteQueryBuilder;
this.parameters = parameters;
}
public static IDeleteQueryBuilder <TRecord> Parameter <TRecord>(this IDeleteQueryBuilder <TRecord> queryBuilder,
string parameterName, object value) where TRecord : class
{
return(queryBuilder.Parameter(new Parameter(parameterName), value));
}
