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