mysql insert fails due to identity = 0

[Anthony]

I have two identical databases in MSSQL and MySQL to test my app. It works perfectly in MSSQL, but it fails after trying to insert in MySQL. The debugger shows it failing right after  

this.context.Add(this.CurrentReport);
this.context.Save();

The debugger also shows this after the Add operation:

OpenAccessEnhancedFlags -1
OpenAccessEnhancedStateManager PCStateMan GeotechReport NEW

The MSSQL run shows the same information, so maybe it isn't significant, but I thought I'd at least mention it. The MySQL database column called RowID is set to be primary key, auto increment, unsigned, not null. The rlinq property called identity mechanism is assigned to DatabaseServerCalculated as the documentation suggests.

What am I missing?

[Anthony]

Well, I can't explain why, but now it works. I deleted the domain model project and started over completely. I did everything the same, but maybe in a different order. I had previously used a domain model that linked to SQL Server 2014 in the project, which I deleted before I added a domain model that linked to MySQL.

I also recreated the underlying table, so maybe I had a setting wrong in one of the two places (the domain model or the table). It works now, though.

[Ralph Waldenmaier]

Hello Anthony,
First I am glad that now your project is working as expected. Nevertheless we would be interested in what was causing the issue. So in case you experience this behavior again, please contact us again.

Feel free to ask in case you have any other question.

Regards,
Ralph Waldenmaier
Telerik