public ISelectable Having(DvlSqlBinaryExpression binaryExpression, IEnumerable <DvlSqlParameter> @params)
{
this.CurrFullSelectExpression.GroupBy.BinaryExpression = binaryExpression;
this.CurrFullSelectExpression.GroupBy.WithParameters(@params);
return(this);
}
public static DvlSqlBinaryExpression NotExp(DvlSqlBinaryExpression binaryExpression) => !binaryExpression;
public static DvlSqlWhereExpression WhereExp(DvlSqlBinaryExpression innerExpression, bool isRoot = false) => new DvlSqlWhereExpression(innerExpression).WithRoot(isRoot);
internal static DvlSqlBinaryExpression SetNot(this DvlSqlBinaryExpression binaryExpression, bool not) => not ? !binaryExpression : binaryExpression;
public ISelectable Having(DvlSqlBinaryExpression binaryExpression)
{
this.CurrFullSelectExpression.GroupBy.BinaryExpression = binaryExpression;
return(this);
}
public IFilter Where(DvlSqlBinaryExpression binaryExpression, IEnumerable <DvlSqlParameter> @params)
{
this.CurrFullSelectExpression.Where = new DvlSqlWhereExpression(binaryExpression).WithParameters(@params) as DvlSqlWhereExpression;
return(this);
}
public IFilter Where(DvlSqlBinaryExpression binaryExpression)
{
this.CurrFullSelectExpression.Where = new DvlSqlWhereExpression(binaryExpression);
return(this);
}
public IInsertDeleteExecutable Where(DvlSqlBinaryExpression binaryExpression, IEnumerable <DvlSqlParameter> @params)
{
this._deleteExpression.WhereExpression = new DvlSqlWhereExpression(binaryExpression).WithParameters(@params) as DvlSqlWhereExpression;
return(this._deleteExecutable =
new SqlInsertDeleteExecutable(this._dvlSqlConnection, ToString, GetDvlSqlParameters));
}
public IInsertDeleteExecutable Where(DvlSqlBinaryExpression binaryExpression)
{
this._deleteExpression.WhereExpression = new DvlSqlWhereExpression(binaryExpression);
return(this._deleteExecutable =
new SqlInsertDeleteExecutable(this._dvlSqlConnection, ToString, GetDvlSqlParameters));
}
public static DvlSqlNotExpression NotExp(DvlSqlBinaryExpression binaryExpression) => new DvlSqlNotExpression(binaryExpression);