private static string GetSqlOperator(SqlOperator sqlOperator)
{
switch (sqlOperator)
{
case SqlOperator.Like:
case SqlOperator.Is:
case SqlOperator.Between:
{
return(sqlOperator.ToString());
}
case SqlOperator.Equal:
{
return("=");
}
case SqlOperator.NotEqual:
{
return("!=");
}
case SqlOperator.GreaterThan:
{
return(">");
}
case SqlOperator.GreaterThanOrEqual:
{
return(">=");
}
case SqlOperator.LessThan:
{
return("<");
}
case SqlOperator.LessThanOrEqual:
{
return("<=");
}
case SqlOperator.IsNot:
{
return("Is Not");
}
default:
{
throw new NotImplementedException($"{nameof(SqlOperator)} {sqlOperator} not recognised in {nameof(SqlText)}.");
}
}
}
public static string ToSqlWhereClause(this List <string> filters, SqlOperator op)
{
return(filters.Count == 0
? (op == SqlOperator.And ? SqlTrue : SqlFalse)
: string.Join($" {op.ToString()} ", filters));
}
