public string GetSql()
{
string command = $"Update {TableName} SET { Utilities.RemoveLastComma(Variables.GetFieldOperandValueasStringorNum())}";
if (WhereFields.Count() > 0)
{
command += $" WHERE {Utilities.RemoveLastComma(WhereFields.GetFieldOperandValueasStringorNum())};";
}
return(command);
}
protected string GetWhere()
{
if (WhereFields.Count() > 0)
{
return($" WHERE {WhereFields.GetFieldOperandValueasStringorNum()}");
}
else
{
return("");
}
}
public string GetSql()
{
string command = "";
if ((WhereFields.Count() > 0) || (AllFields))
{
command = $"DELETE {DeleteAll()} FROM {TableName}";
if (WhereFields.Count() > 0)
{
command += $"WHERE {Utilities.RemoveLastComma(WhereFields.GetFieldOperandValueasStringorNum())};";
}
}
return(command);
}