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";
