public string AsSQLString() { var sb = new StringBuilder(); var fld = string.IsNullOrWhiteSpace(QueryField) ? "{Select a field}" : SQLExpressionFunctions.GetEscapedValue(QueryField); if (FirstVal is null) { sb.Append($"{fld} LIKE {{Add Items}}"); } else { sb.Append($"{fld} LIKE {Surrounder}%{string.Join($"%{Surrounder} AND {fld} LIKE {Surrounder}%", Values)}%{Surrounder}"); } sb.Insert(0, "("); sb.Append(")"); return(sb.ToString()); }
public string ParameterizedString() { if (string.IsNullOrWhiteSpace(QueryField) || Values is null || Values.Count == 0) { return(null); } var fld = SQLExpressionFunctions.GetEscapedValue(QueryField); var sb = new StringBuilder(); for (var i = 0; i < Values.Count; i++) { if (sb.Length > 0) { sb.Append(" OR "); } sb.Append($"{fld} LIKE @value{Order}_{i}"); } sb.Insert(0, "("); sb.Append(")"); return(sb.Insert(0, "NOT (").Append(")").ToString()); }
public string ParameterizedString() => $"{SQLExpressionFunctions.GetEscapedValue(QueryField)} is not null";
public string AsSQLString() => $"{(string.IsNullOrWhiteSpace(QueryField) ? "{Select a field}" : SQLExpressionFunctions.GetEscapedValue(QueryField))} is not null";