public override bool ToCommand(IDaoProvider provider, SqlCommandBuilder builder, ISqlParameters parameters)
{
object value = parameters.Resolve(ParamName);
if (_valueParameterClauseUsage == ValueParameterClauseUsage.In)
{
builder.AppendCommandText(ToInClauseSqlString(provider, value));
}
else
{
String content = ToSqlString(provider, value);
if (String.IsNullOrEmpty(content) && !String.IsNullOrEmpty(_defaultValue))
{
builder.AppendCommandText(_defaultValue);
}
else
{
if (_valueParameterClauseUsage == ValueParameterClauseUsage.Like)
{
content = provider.EscapeLikeParamValue(content);
}
builder.AppendCommandText(content);
}
}
return(true);
}
public override bool ToCommand(IDaoProvider provider, SqlCommandBuilder builder, ISqlParameters parameters)
{
string sqlName = provider.EscapeParam(ParamName);
builder.AppendCommandText(RawText.Replace(ParamName, sqlName));
builder.AddCommandParameter(sqlName, parameters.Resolve(ParamName));
return(true);
}
