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); }