/// <summary> /// Converts the current WhereCondition to an SQL Query /// </summary> public static string ToQuery(WhereSeparator ws, params IWhereCondition[] conditions) { if (conditions.Length == 0) { return(string.Empty); } var sb = new StringBuilder(); sb.Append("("); for (var i = 0; i < conditions.Length; i++) { sb.Append(conditions[i].ToQuery()); if (i < conditions.Length - 1) { sb.Append(" " + ws.ToQuery() + " "); } } sb.Append(")"); return(sb.ToString()); }
/// <summary> /// Converts a WhereSeparator to a string /// </summary> public static string ToQuery(this WhereSeparator ws) { switch (ws) { case WhereSeparator.And: return("AND"); case WhereSeparator.Or: return("OR"); default: return(string.Empty); } }