"Modifying a column with the 'Identity' pattern is not supported" exception occur while saving changes

Question

Hi All!

I have a simple table "MyEntities" with identity column "Id" and I unable to save my changes if I get OptimisticConcurrencyException:

                try
                {
                    ctx.SaveChanges();
                }
                catch (OptimisticConcurrencyException)
                {
                    ctx.Refresh(RefreshMode.ClientWins, ctx.MyEntities);

                    //at this point I get UpdateException whose innter exception contains this:
		    //"Modifying a column with the 'Identity' pattern is not supported. Column: 'Id'.
                    ctx.SaveChanges();
                    
                    Console.WriteLine("OptimisticConcurrencyException handled and changes saved.");
                }

How do I handle this situation?

Thanks.

Answer 1

Hello Dmitriano,

Properties mapped to columns that are marked as store generated with the identity pattern cannot really be modified. I suspect the issue could be that some part of the code you use to modify the property values in your entities is attempting to do just that, but because you haven’t included that part of the code in your post, I cannot tell for sure.

Hope this helps,
Diego

---

This posting is provided "AS IS" with no warranties, and confers no rights.