Updating database records
For now, let s use the Properties window in the Designer, although the Configure Data Source wizard or declarative syntax option would work just as well.From the Designer in Sql Data Source and then bring up the Properties window (from the View menu, choose Properties window, or simply hit F4).
Db Update Concurrency Exception: Store update, insert, or delete statement affected an unexpected number of rows (0).
Alternatively, the Sql Data Source can be used in place of the Object Data Source.
Recall that to support inserting, updating, and deleting, with the Object Data Source we needed to specify the object layer methods to invoke to perform the insert, update, or delete action.
Concurrency is always tricky, but I am assuming that you just want your updates to win.
Refresh Object State Manager entrie So you have an entity that is updated, and you want to update it in the database with the least amount of code...
The columns that are not on the list retain their original values.