| > |
EXPERT RESPONSE
Generally, if you're going to perform operations on multiple databases/servers, you must use Enterprise Services (i.e. your classes inheriting from ServicedComponent). If you're working against a single database, try using manual transactions, or some approach like the one in CodeProject (http://codeproject.com/dotnet/declarativetransactions.asp), and using optimistic concurrency whenever you can. The tradicional way of doing this is retrieving timestamps for the rows you're using, and then comparing these timestamps with the current ones on the database. If they don't match, someone else's modified it, and you usually show the user both the actual values and his proposed changes, and let him chose which ones should prevail.
|
|
