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.