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