I get the "you have an error in your sql syntax entity framework" while trying to update the data in my MySQL database. I'm developing an MVC 4 ASP.NET application using a .edmx file to interact with the database.
This is my case: I have two tables: A and B. A has many B's and B has many A's so i made a C table with a foreign key to A and a foreign key to B. Now i'm trying to delete one of those rows in C. As i step on the
What happened is that at the moment of executing
db.SaveChanges() (after an update), the .edmx tried to update the rows in the 'C' table, but as this table only had two foreign keys to A and B, the update operation wasn't supported. This is the solution that I found in other post in StackOverflow, and it worked for me:
Schema="dbo(remove the "store:")
Note: this was moved from the question and posted on the OP's behalf.