Error when updating if nothing is changed
Posted: Thu 15 May 2014 04:53
Hi
I’m currently trialling your connector for MySql v8.3.146.6 and I’ve hit a problem.
I’m working through the code first tutorial here:
http://www.asp.net/mvc/tutorials/gettin ... pplication
and when I try to update a student and press save without changing anything I get this error:
DbUpdateConcurrencyException was unhandled by user code:
Store update, insert or delete statement affected an unexpected number of rows (0).
If I change a value it saves correctly. I have also tried this using a local MS SQL database and it works fine. I think I have made all the changes I need to in the web.config and the tables created correctly in the MySQL db with the correct seed data so everything was working up to this point.
Is there anything else I can try?
Regards
Brian
I’m currently trialling your connector for MySql v8.3.146.6 and I’ve hit a problem.
I’m working through the code first tutorial here:
http://www.asp.net/mvc/tutorials/gettin ... pplication
and when I try to update a student and press save without changing anything I get this error:
DbUpdateConcurrencyException was unhandled by user code:
Store update, insert or delete statement affected an unexpected number of rows (0).
If I change a value it saves correctly. I have also tried this using a local MS SQL database and it works fine. I think I have made all the changes I need to in the web.config and the tables created correctly in the MySQL db with the correct seed data so everything was working up to this point.
Is there anything else I can try?
Regards
Brian