CRUD best solution

Hi,

 in our latest project we have decided to use OpenAccess, really nice tool, but I have a question. How would You suggest to organize CRUD operations. In fact the biggest problem I have to face is update. If I understand correctly Update of an object has to be between Transaction.Begin(), Commit?

If so do I need to always select this object from the database (i.e. extent.FirstorDefault or whatever) and than copy all updated properites from the object outside the begin-commit block? Or maybe there is better solution...

Greetings
M.

Hello Michal,

Yes, all the updates should be made during an active transaction. What I can suggest you to make the process easier is using scope.TransactionProperties.AutomaticBegin = true. When this option is enabled, a transaction is automatically started after Commit() or Rollback(). However, you will still have to call manually scope.Transaction.Commit() to persist the changes.
You are right about the second question as well. If you have an object which is not 'attached' to an object scope, its changes could not be tracked and you will have to copy them manually to the actual object.

Sincerely yours,
Alexander
the Telerik team