public override void AppendSql([NotNull] StringBuilder builder, [NotNull] GeneratorContext filterParams) { if (IsValue) { var value = Value; if (value is null) { builder.Append("NULL"); } else { var paramName = filterParams.Add(Value); builder.Append(Dialect.GetParameterReference(paramName)); } } else { if (!_skipBrackets) { builder.Append(Dialect.OpenBracket); } _left.AppendSql(builder, filterParams); builder.Append(" = "); _right.AppendSql(builder, filterParams); if (!_skipBrackets) { builder.Append(Dialect.CloseBracket); } } }
/// <inheritdoc /> public override void AppendSql(StringBuilder builder, GeneratorContext filterParams) { if (!SkipBrackets) { builder.Append(Dialect.OpenBracket); } if (_emptyEnumOperation != null) { _emptyEnumOperation.AppendSql(builder, filterParams); } else { // ReSharper disable once PossibleNullReferenceException _left.AppendSql(builder, filterParams); builder.Append(" " + Dialect.InKeyword + " "); builder.Append(Dialect.OpenBracket); // ReSharper disable once PossibleNullReferenceException using var enumerator = _values.GetEnumerator(); IFilterOperation first = null; while (enumerator.MoveNext()) { var current = enumerator.Current; if (first != null && current != null) { builder.Append(", "); } else { first = enumerator.Current; } current?.AppendSql(builder, filterParams); } builder.Append(Dialect.CloseBracket); } if (!SkipBrackets) { builder.Append(Dialect.CloseBracket); } }
public override void AppendSql([NotNull] StringBuilder builder, [NotNull] GeneratorContext filterParams) { if (!SkipBrackets) { builder.Append(Dialect.OpenBracket); } _left.AppendSql(builder, filterParams); builder.Append(" " + Dialect.LikeKeyword + " "); _right.AppendSql(builder, filterParams); if (!SkipBrackets) { builder.Append(Dialect.CloseBracket); } }
public override void AppendSql([NotNull] StringBuilder builder, [NotNull] GeneratorContext filterParams) { builder.Append(Dialect.NotKeyword + " " + Dialect.OpenBracket); _expression.AppendSql(builder, filterParams); builder.Append(Dialect.CloseBracket); }