I have run into a problem with optimistic concurrency in my dynamic data application (where all relevant settings are at their default values); when I try to update or delete one of my tables, I see the following error:
Exception type: ChangeConflictException
Exception message: Row not found or changed.
I am the only user of my database at the moment, so I can guarantee that the data both exists and has not been changed outside the application!
Various forums have suggested that the way to deal with this is to set the column attributes so that the concurrency checking is disabled; i.e.
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PropSurname", DbType="NVarChar(255)", UpdateCheck=UpdateCheck.Never)]
However, to do this manually through the Visual Studio designer will take me hours (I have a lot of tables) and if I then change the schema of one of the tables in the DB, won't I then have to do it all again? I've tried editing the .designer.cs file directly but my changes are subsequently overwritten (as expected).
All suggestions gratefully received!
View Complete Post