/// <summary>
/// Generates the DELETE command string.
/// </summary>
public string GenerateStatement()
{
if (string.IsNullOrEmpty(_table))
{
throw new Exception("Table is not set.");
}
StringBuilder sb = new StringBuilder($"DELETE FROM {Util.FormatSQL(_table)}");
if (_condition != null)
{
sb.Append($" {_condition.GenerateStatement()}");
}
return(sb.ToString());
}
/// <summary>
/// Generates the actual UPDATE command string.
/// </summary>
public string GenerateStatement()
{
if (_newColumnValues.Count == 0)
{
throw new Exception("Can't update table without columns to be updated.");
}
StringBuilder sb = new StringBuilder($"UPDATE {SqlTableHelper.GetTableName<T>()} SET ");
for (int i = 0; i < _newColumnValues.Count; i++)
{
var colVal = _newColumnValues[i];
sb.Append($"{Util.FormatSQL(colVal.Column)}={colVal.Value}");
if (i < _newColumnValues.Count - 1)
{
sb.Append(", ");
}
}
sb.Append(_condition?.GenerateStatement());
return(sb.ToString());
}
