public String ToSqlString(IlikeExpression ilike) { StringBuilder sb = StringHelper.CreateBuilder(); if (_factory.Dialect is PostgreSQLDialect) { sb.Append(ilike.Expression.Render(this)) .Append(" ilike "); } else { sb.Append(_factory.Dialect.LowercaseFunction) .Append('(').Append(ilike.Expression.Render(this)).Append(')') .Append(" like "); } String value = ilike.MatchMode.ToMatchString(ilike.Value); if (Parameterized) { sb.Append(RegisterParam(value)); } else { sb.Append("'").Append(value).Append("'"); } return(sb.ToString()); }
public String ToSqlString(IlikeExpression ilike) { StringBuilder sb = StringHelper.CreateBuilder(); if (_factory.Dialect is PostgreSQLDialect) sb.Append(ilike.Expression.Render(this)) .Append(" ilike "); else sb.Append(_factory.Dialect.LowercaseFunction) .Append('(').Append(ilike.Expression.Render(this)).Append(')') .Append(" like "); String value = ilike.MatchMode.ToMatchString(ilike.Value); if (Parameterized) sb.Append(RegisterParam(value)); else sb.Append("'").Append(value).Append("'"); return sb.ToString(); }