On my previous project, I used a record version field in the table to check for concurrency. iRecVersion is an integer field and defaulted to 1. When I update a record, increment iRecVersion and check if it's the same:

UPDATE Customers SET Name = @sName, iRecVerion = iRecVersion + 1
WHERE iRecVersion = @iRecVer

Is this a recommended method in MM.NET? What is the best way to implement this in MM.NET?