Error when updating if nothing is changed

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
bgraham1962
Posts: 2
Joined: Thu 15 May 2014 04:17

Error when updating if nothing is changed

Post by bgraham1962 » 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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Error when updating if nothing is changed

Post by Shalex » Thu 15 May 2014 11:17


bgraham1962
Posts: 2
Joined: Thu 15 May 2014 04:17

Re: Error when updating if nothing is changed

Post by bgraham1962 » Thu 15 May 2014 21:25

Thanks, that solved it.

Post Reply