/// <summary>
/// Removes the instance from the database.
/// </summary>
public void Remove()
{
DbCommand command = DatabaseEngine.Instance.CreateCommand();
command.CommandText = "delete from Account where AccountId=@AccountId";
DatabaseEngine.AddLongParameter(command, "@AccountId", this._accountId);
command.ExecuteNonQuery();
}
/// <summary>
/// Writes the Account instance back to the database.
/// </summary>
public void Persist()
{
if (_dirty)
{
DbCommand command = DatabaseEngine.Instance.CreateCommand();
command.CommandText = "update Account set Bio=@Bio, HitPoints=@HitPoints, Mana=@Mana, PasswordHash=@PasswordHash, PlaneId=@PlaneId, RaceId=@RaceId where AccountId=@AccountId";
DatabaseEngine.AddLongParameter(command, "@AccountId", this._accountId);
DatabaseEngine.AddLongParameter(command, "@HitPoints", this._hitPoints);
DatabaseEngine.AddLongParameter(command, "@PlaneId", this._plane.Elevation);
DatabaseEngine.AddLongParameter(command, "@RaceId", this._race.RaceId);
DatabaseEngine.AddLongParameter(command, "@Mana", this._mana);
DatabaseEngine.AddStringParameter(command, "@Bio", this._bio);
DatabaseEngine.AddStringParameter(command, "@PasswordHash", this._passwordHash);
command.ExecuteNonQuery();
}
}