Rod,
What approach do you use ?We've used optimistic locking for over a decade, starting in 1995 when we converted all our pessimistic locking FP stuff to VFP views.
I don't believe it is possible to use pessimistic locking in a web app or similar stateless scenario, so we've carried on using optimistic there as well.
If I were to embrace NET, I'd expect to keep doing the same. Hence my interest in change tracking in NET object/entities which are tailormade for data transfer if you own both ends. But change tracking *has* to accompany the data if you want your tiers to ship data and forget about it unless it comes back, which is essential if you want to reuse classes in stateless apps.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
