Andres Aguiar's Weblog

Frans also blogs about Optimistic Concurrency.

Frans got to the conclusion that we don't need O/R mappers in a SOA world. He argues that a 'Manager' model that provides services to data would be a better choice.

I'll be attending to the MDC in March, and I'll be doing a presentation on the new DeKlarit features for the Compact Framework and SQL Server CE. Below is the abstract:

Updates in distributed application usually involve performing optimistic locking on the data to be updated. This requires to store a copy of the previous column values or to have a 'version' field in the database table to compare against it.

The results are online.

A couple of weeks ago, I was in the Netherland Antilles doing a training course on DeKlarit to a group of around 10 developers. They found a very good solution to a quite common problem which is how to maintain an audit trail of the changes in database tables.

Some time ago we found severe normalizations issues with Microsoft's PetShop implementation (which by the way were fixed in the 3.0 version).

When a user gets an optimistic locking exception, his usual behavior is to confirm the changes he made overwriting the existing ones.