Optimistic Locking
Posted: Mon 21 Mar 2011 16:04
Gents could anyone point me to an implimentation of Optimistic locking using EF4 POCO objects?
Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
CREATE OR REPLACE TRIGGER MyTableConcur
BEFORE UPDATE ON MyTable FOR EACH ROW
BEGIN
:NEW."Version" := :OLD."RowsetVersion" + 1;
-- alternative: :NEW."Version" := current_timestamp;
END MyTableConcur;