OA SQL Generator

2 posts, 0 answers
  1. Daniel Bichuete
    Daniel Bichuete avatar
    9 posts
    Member since:
    Sep 2009

    Posted 15 Oct 2010 Link to this post

    Hi,

     I have one doubt regarding the SQL statement that is generated for SQL Server. Let me explain better. Let's assume we query database for an object (L2 cache is turned on). Then we modify some property to SAME value it already had in past. I have noticed that OA generates an UPDATE query containing the changed property that hasnt changed value indeed. Is this expected behavior ?

     I'm not quite familiar with OA, migrating now and dont have a full understand about some internal work.

    Best regards,

    Daniel Bichuete

  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 18 Oct 2010 Link to this post

    Hi Daniel Bichuete,

    OpenAccess tries to avoid such empty updates by comparing the old with the new values for strings and value types. However, when the old value is not known (because it was not fetched yet),  the equality test is skipped. Can this be the case in your scenario?

    Greetings,
    Thomas
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
Back to Top