public string GetSqlWithParameters() { string command = $"Update {TableName} SET { Utilities.RemoveLastComma(Variables.GetFieldOperandParameter("@U"))}"; if (WhereFields.Count() > 0) { command += $" WHERE {Utilities.RemoveLastComma(WhereFields.GetWhereFieldEqualsParameter("@W"))};"; } return(command); }
protected string GetWhereParam() { if (WhereFields.Count() > 0) { return($" WHERE {WhereFields.GetWhereFieldEqualsParameter("@W")}"); } else { return(""); } }
public string GetSqlWithParameters() { string command = ""; if ((WhereFields.Count() > 0) || (AllFields)) { command = $"DELETE {DeleteAll()} FROM {TableName}"; if (WhereFields.Count() > 0) { command += $"WHERE {Utilities.RemoveLastComma(WhereFields.GetWhereFieldEqualsParameter())};"; } } return(command); }