m:n relation update problem

Thread is closed for posting
2 posts, 0 answers
  1. Fabio Renggli
    Fabio Renggli avatar
    4 posts
    Member since:
    Dec 2009

    Posted 04 Jan 2011 Link to this post

    Hi together

    I have the following m:n relation. Instrument -> InstrumentID. It is implemented with a join table. The problem is now, that when i want to add an existing InstrumentID to two new Instrument at the same time i get a OptimisticverificationException, because openaccess always updates the existing InstrumentID even has the same value. (voa_version is increased). The only thing openaccess should do is to create a new entry in the join table. Can anyone tell me why this is happening, and how it could be solved?

    Thanks and regards

    Fabio Renggli
  2. Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 04 Jan 2011 Link to this post

    Hello Fabio Renggli,
    Do you need the version field? If you set the concurrency mode to 'changed' it should work.

    Kind regards,
    Jan Blessenohl
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Back to Top