The solution of inserting or updating Datagram errors in EF (EntityFramework)

Error message: Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions.

Reference:

Https://stackoverflow.com/questions/1836173/entity-framework-store-update-insert-or-delete-statement-affected-an-unexpec

Reason: the primary key id is not set for self-increment, resulting in insertion failure.

Solution: the table's primary key id setting increments itself.

Mysql setting method: right-click on the table-- > Design table-- > select the primary key id-- > check it.

Sqlserver setting method: right-click on the table-- > Design Table-- > Select the primary key id-- > double-click the value of "(is identification)", and change to yes, the identification increment and identification seed can be set to 1.

The above EF (EntityFramework) insert or update data report error solution is the editor to share with you all the content, I hope to give you a reference, but also hope that you support more.