>Sorry if this is a stupid question, but what's the best to handle record locking in .NET with SQL using C#. I know from VFP we do rlock or cursorsetprop() but I am specifically looking, for instance, to prevent two users from updating the same customer record.
>
>ADO, LINQ, any advice is appreciated. Thank you in advance.
I don't really lock the record, but I have a UpdateDate field that I check whenever the record is updated. I use that to check the "version" of the record before I allow the update.