This is a migrated thread and some comments may be shown as answers.

OA SQL Generator

1 Answer 106 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Daniel Bichuete
Top achievements
Rank 1
Daniel Bichuete asked on 15 Oct 2010, 02:47 PM

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

1 Answer, 1 is accepted

Sort by
0
Thomas
Telerik team
answered on 18 Oct 2010, 03:46 PM
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
Tags
General Discussions
Asked by
Daniel Bichuete
Top achievements
Rank 1
Answers by
Thomas
Telerik team
Share this question
or