public TValue this[TKey key]
{
get { return(_dict[key]); }
set
{
if (!_dict.ContainsKey(key))
{
Add(key, value);
}
else
{
var stm = string.Format("UPDATE {0} SET {1} WHERE {2}",
_tableName,
DBFields <TValue> .FieldsAndValues(value, " , "),
DBFields <TKey> .FieldsAndValues(key, " AND "));
if (ExecuteNonQuery(stm))
{
_dict[key] = value;
}
}
}
}
public bool Remove(TKey key)
{
var stm = string.Format("DELETE FROM {0} WHERE {1}", _tableName, DBFields <TKey> .FieldsAndValues(key, " AND "));
return(ExecuteNonQuery(stm) && _dict.Remove(key));
}