/// <summary>
/// Creates a where clause to add to the query's where statement
/// </summary>
/// <param name="field">The column name</param>
/// <returns></returns>
public SqlExpression <SelectWhereStatement> Where(string field)
{
if (WhereStatement.InnerClauseOperator == LogicOperator.And)
{
return(WhereStatement.And(field));
}
else
{
return(WhereStatement.Or(field));
}
}
/// <summary>
/// Creates a where clause to add to the query's where statement
/// </summary>
/// <param name="field">The column name</param>
/// <param name="operator">The Comaparison Operator to use</param>
/// <param name="compareValue">The value, for the column name and comparison operator</param>
/// <returns></returns>
public SelectWhereStatement Where(string field, Comparison @operator, object compareValue)
{
if (WhereStatement.InnerClauseOperator == LogicOperator.And)
{
return(WhereStatement.And(field, @operator, compareValue));
}
else
{
return(WhereStatement.Or(field, @operator, compareValue));
}
}