ApplyPropertyChanges problem with SQL Server timestamp

Question

Hi,

I'm using SQL Server Timestamp field with ConcurrencyMode="Fixed" for  concurrency check. On the EntityObject this field is mapped to byte array. The problem occurs with ApplyPropertyChanges - ObjectStateManager always marks this byte array for the timestamp as modified even if it didn't changed. Please advise solution or workaround.

Thanks in advance,
Olga

Answer 1

Hi Olga,

Have you set the timestamp value of the new item?
If you havn't, it is null by default. That's why that you got it modified.
For the timestamp value, we usually use the original value in DB for the concurrency reason. 

There are some related aricles for your reference,
http://cs.rthand.com/blogs/blog_with_righthand/archive/2007/05/02/Inserting_2F00_Updating_2F00_Deleting-records-containing-timestamp-columns-in-ADO.NET-Entity-Framework.aspx
http://www.cnblogs.com/idior/archive/2005/08/06/208887.aspx
http://stackoverflow.com/questions/377916/using-entity-framework-should-i-add-a-timestamp-to-all-my-database-tables


Does this work for you?

Best Regards
Yichun Feng

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.