public string BuildQuery() { string queryString = "UPDATE " + _table + " SET"; for (int i = 0; i < _set.Count; i++) { queryString += " " + _set.Keys[i] + "=" + Escape.EscapeString(_set[_set.Keys[i]]) + (i + 1 == _set.Count ? ("") : (",")); } if (_whereStatement.ClauseLevels > 0) { queryString += " WHERE " + _whereStatement.BuildWhereStatement(); } queryString += ";"; return(queryString); }
public string BuildQuery() { string queryString = "INSERT INTO " + _table + " ("; for (int i = 0; i < _value.Count; i++) { queryString += _value.Keys[i] + (i + 1 == _value.Count ? "" : ","); } queryString += ") VALUES ("; for (int i = 0; i < _value.Count; i++) { queryString += Escape.EscapeString(_value[_value.Keys[i]]) + (i + 1 == _value.Count ? ("") : (",")); } queryString += ");"; return(queryString); }