protected override void AppendWhereCondition(
[NotNull] StringBuilder commandStringBuilder,
[NotNull] ColumnModification columnModification,
bool useOriginalValue)
{
Check.NotNull(commandStringBuilder, nameof(commandStringBuilder));
Check.NotNull(columnModification, nameof(columnModification));
SqlGenerationHelper.DelimitIdentifier(commandStringBuilder, columnModification.ColumnName);
var parameterValue = useOriginalValue
? columnModification.OriginalValue
: columnModification.Value;
if (parameterValue == null)
{
commandStringBuilder.Append(" IS NULL");
}
else
{
commandStringBuilder.Append(" = ");
if (!columnModification.UseCurrentValueParameter &&
!columnModification.UseOriginalValueParameter)
{
AppendSqlLiteral(commandStringBuilder, columnModification.Value, columnModification.Property);
}
else
{
SqlGenerationHelper.GenerateParameterNamePlaceholder(
commandStringBuilder, useOriginalValue
? columnModification.OriginalParameterName
: columnModification.ParameterName);
}
}
}
protected override void AppendWhereCondition(
StringBuilder commandStringBuilder,
ColumnModification columnModification,
bool useOriginalValue)
{
if (commandStringBuilder == null)
{
throw new ArgumentNullException(nameof(commandStringBuilder));
}
if (columnModification == null)
{
throw new ArgumentNullException(nameof(columnModification));
}
SqlGenerationHelper.DelimitIdentifier(commandStringBuilder, columnModification.ColumnName);
var parameterValue = useOriginalValue
? columnModification.OriginalValue
: columnModification.Value;
if (parameterValue == null)
{
commandStringBuilder.Append(" IS NULL");
}
else
{
commandStringBuilder.Append(" = ");
if (!columnModification.UseCurrentValueParameter &&
!columnModification.UseOriginalValueParameter)
{
AppendSqlLiteral(commandStringBuilder, columnModification, null, null);
}
else
{
SqlGenerationHelper.GenerateParameterNamePlaceholder(
commandStringBuilder, useOriginalValue
? columnModification.OriginalParameterName
: columnModification.ParameterName,
columnModification.ColumnType);
}
}
}
