OptimisticConcurrencyException
Posted: Tue 12 Jun 2012 04:25
Hello,
I am having a problem with the latest version of dotConnect for MySQL, v. 7.0.17.0 and Entity Framework 4 with Timestamp fields and Concurrency Mode = Fixed
Trying to update a record in "Table1", generates a second unexpected update query for "Table2" like this:
I guess this is throwing an OptimisticConcurrencyException because no records are modified and ROW_COUNT() = 1 is not true.
Table1 contains a FK relation to Table2 but the point is that I am not trying to change records in Table2.
Any suggestion?
Regards.
G.A.
I am having a problem with the latest version of dotConnect for MySQL, v. 7.0.17.0 and Entity Framework 4 with Timestamp fields and Concurrency Mode = Fixed
Trying to update a record in "Table1", generates a second unexpected update query for "Table2" like this:
Code: Select all
UPDATE Table2
SET `TimeStamp` = `TimeStamp`
WHERE MyID = 3916 AND `TimeStamp` = '2012-01-01 00:00:00';
SELECT `TimeStamp`
FROM Table2
WHERE MyID = 3916 AND ROW_COUNT() = 1;Table1 contains a FK relation to Table2 but the point is that I am not trying to change records in Table2.
Any suggestion?
Regards.
G.A.