Update

To UPDATE the existing object we simply call the same db.Store function.

This method stores an object in the database. If the object is present in the database, it will be updated, otherwise it will be inserted.

For example:

//Get the object we would like to work with.

Parameters param = db.CreateParameters();

param["location"] = "Sydney";

Cinema cinema = (Cinema)db.ExecuteScalar("SELECT Cinema WHERE Location = @location", 0, param);

//Change that object

cinema.Location = "Melbourne";

//Store it back

//Object will be updated

db.Store(cinema);