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.