With optimistic concurrency a row in the SQL table is not locked. Instead, when the row is updated,the application checks to determine whether the row has been modified 1) since it was read. If the row has been modified, a RecordContentionException is thrown.