Here's a possible solution that will provide optimistic locking using SubSonic 3.0 ActiveRecord:

http://sites.google.com/site/subsonicoptimistic/home