A better way to think about it is "how do I mitigate concurrency?" or "what
contengency to handle concurrency?"
The best way to avoid concurrency errors is to move into something like
DiffGrams or UpdateGrams (version of database and SQL XML can dictate here)
and prepare to switch to update statements when you get concurrency issues.
Ignoring them (coding around) can cause different problems.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge
**********************************************************************
Think outside the box!
**********************************************************************