Locking objects with Transaction.Lock ()

[Anatol]

Hi to all.
Telerik.OpenAccess 2010.2.714.1 + Firebird 2.5 RC2
I'm trying to realize such construction.
In the database the original objects and user's customization settings for some ones from them are stored. I want load original objects, apply user's setings for it and show customized objects in view for edit. All futher new settings also store in user's settings class (mutliuser application). Each user can insert or delete user's objects (not "standard") and make custom settings ("edit") all objects.
I make a transaction with PESSIMISTIC_EXPLICIT mode, load original objects and trying to lock with
ScopeProvider.ObjectScope().Transaction.Lock(MyCollectionOfObjects, LockMode.WRITE);
after editing this collection in UI there are dirty objects in the scope and after Transaction.Commit() all changes in "locked" original objects are stored in database instead user's settings.
Maybe, I don't inderstand a purpose of Transaction.Lock () method or use it not correctly?
Please, help me with my problem. If you know other ways to solve my problem would be happy to see them.

[Ady]

Hello 1,

 Are the 'User setting' objects locked and modified in the UI? If you want to take care of concurrency issues have you considered the Optimistic Concurrency support by OpenAccess. You can find more about various Concurrency control mechanisms, here.

All the best,
Ady
the Telerik team