Solution for Store update, insert, or delete statement affected an unexpected number of rows (0)

最新推荐文章于 2022-11-09 17:02:02 发布

zhangbp

最新推荐文章于 2022-11-09 17:02:02 发布

阅读量3.6k

点赞数

分类专栏：工作随想文章标签： insert delete concurrency binding class mvc

本文链接：https://blog.csdn.net/zhangbp/article/details/7908094

版权

工作随想专栏收录该内容

21 篇文章 0 订阅

订阅专栏

When i create CYTestDeptTrainWebsite via MVC3, i got blocking issue: Store update, insert, or delete statement affected an unexpected number of rows (0)...

type the solution on here:

In the Album class, you've defined [Bind(Exclude = "AlbumId")] on the class, which means that the code won't try and bind the AlbumId from the form. Which is fine, except that on the edit page, you're passing in a populated Album, which is presumably being populated using binding, which is of course ignoring the Album Id, so the AlbumId of the object passed into the edit method, is always 0, which throws a misleading concurrency error, because no rows are affected, because there's no album with ID of 0.

If you remove the bind/exclude attribute, then the edit page works as expected.