Error when updating if nothing is changed

Error when updating if nothing is changed

Postby 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/getting-started-with-ef-using-mvc/creating-an-entity-framework-data-model-for-an-asp-net-mvc-application

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
bgraham1962
 
Posts: 2
Joined: Thu 15 May 2014 04:17

Re: Error when updating if nothing is changed

Postby Shalex » Thu 15 May 2014 11:17

Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44

Re: Error when updating if nothing is changed

Postby bgraham1962 » Thu 15 May 2014 21:25

Thanks, that solved it.
bgraham1962
 
Posts: 2
Joined: Thu 15 May 2014 04:17


Return to dotConnect for MySQL