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();
}
