public String ToSqlString(LikeExpression like)
{
StringBuilder sb = StringHelper.CreateBuilder();
if (like.IgnoreCase)
{
sb.Append(_factory.Dialect.LowercaseFunction)
.Append('(').Append(like.Expression.Render(this)).Append(')');
}
else
{
sb.Append(like.Expression.Render(this));
}
sb.Append(" like ");
String value = like.MatchMode.ToMatchString(like.Value);
if (Parameterized)
{
sb.Append(RegisterParam(value));
}
else
{
sb.Append("'").Append(value).Append("'");
}
if (like.EscapeChar != null)
{
sb.Append(" escape \'").Append(like.EscapeChar).Append("\'");
}
return(sb.ToString());
}
public String ToSqlString(LikeExpression like)
{
StringBuilder sb = StringHelper.CreateBuilder();
if (like.IgnoreCase)
sb.Append(_factory.Dialect.LowercaseFunction)
.Append('(').Append(like.Expression.Render(this)).Append(')');
else
sb.Append(like.Expression.Render(this));
sb.Append(" like ");
String value = like.MatchMode.ToMatchString(like.Value);
if (Parameterized)
sb.Append(RegisterParam(value));
else
sb.Append("'").Append(value).Append("'");
if (like.EscapeChar != null)
sb.Append(" escape \'").Append(like.EscapeChar).Append("\'");
return sb.ToString();
}
