void InlineDbCommandCondition.AddToCommand(IDbCommand command, StringBuilder commandText, DatabaseInfo databaseInfo, string parameterName)
{
var parameter = columnValue.GetParameter(name: parameterName);
var operatorString = "<=";
if (op == Operator.GreaterThan)
{
operatorString = ">";
}
if (op == Operator.GreaterThanOrEqualTo)
{
operatorString = ">=";
}
if (op == Operator.LessThan)
{
operatorString = "<";
}
commandText.Append(columnValue.ColumnName);
commandText.Append(" ");
commandText.Append(operatorString);
commandText.Append(" ");
commandText.Append(parameter.GetNameForCommandText(databaseInfo));
command.Parameters.Add(parameter.GetAdoDotNetParameter(databaseInfo));
}
void InlineDbCommandCondition.AddToCommand(IDbCommand command, DatabaseInfo databaseInfo, string parameterName)
{
var parameter = columnValue.GetParameter(name: parameterName);
string operatorString;
switch (op)
{
case Operator.NotEqualTo:
operatorString = "!=";
break;
case Operator.LessThan:
operatorString = "<";
break;
case Operator.GreaterThan:
operatorString = ">";
break;
case Operator.LessThanOrEqualTo:
operatorString = "<=";
break;
case Operator.GreaterThanOrEqualTo:
operatorString = ">=";
break;
default:
throw new ApplicationException("unknown operator");
}
command.CommandText += columnValue.ColumnName + " " + operatorString + " " + parameter.GetNameForCommandText(databaseInfo);
command.Parameters.Add(parameter.GetAdoDotNetParameter(databaseInfo));
}
void InlineDbCommandCondition.AddToCommand(IDbCommand command, DatabaseInfo databaseInfo, string parameterName)
{
var parameter = columnValue.GetParameter(name: parameterName);
if (parameter.ValueIsNull)
{
command.CommandText += columnValue.ColumnName + " IS NULL";
}
else
{
command.CommandText += columnValue.ColumnName + " = " + parameter.GetNameForCommandText(databaseInfo);
command.Parameters.Add(parameter.GetAdoDotNetParameter(databaseInfo));
}
}
