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)); }