private string ResolveOperator(WhereStatementOperator statementOperator)
{
switch (statementOperator)
{
case WhereStatementOperator.In:
return("IN");
case WhereStatementOperator.GreaterThen:
return(">");
case WhereStatementOperator.LessThen:
return("<");
case WhereStatementOperator.GreaterThenOrEquals:
return(">=");
case WhereStatementOperator.LessThenOrEquals:
return("<=");
case WhereStatementOperator.NotEqual:
return("<>");
default:
return("=");
}
}
public IQueryBuilderWhere Where(string columnName, object value, WhereStatementOperator statementOperator)
{
m_whereStatements.Add(new WhereStatement(columnName, value, statementOperator));
return(this);
}
public WhereStatement(string columnName, object value, WhereStatementOperator statementOperator = WhereStatementOperator.Equals)
{
ColumnName = columnName;
Value = value;
StatementOperator = statementOperator;
}
