1

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 db.SaveChanges(); line, it throws me an exception that says what i already mentioned.

Does anybody know how can I fix it?

Improve this question
9
  • 2
    Check if there is a message in the InnerException. Commented Aug 5, 2014 at 16:04
  • And please also provide a full stack trace for the exception Commented Aug 5, 2014 at 16:13
  • 1
    Please edit your post to include any additional information you have to your question. Avoid adding this in the comments, as they are harder to read and can be deleted easier. The edit button for your post is just below the post's tags. Commented Aug 5, 2014 at 19:11
  • 1
    @Basic sorry, i'm new to posting questions in StackOverflow. By the way, I already found the solution to my problem! Thanks anyways! Commented Aug 6, 2014 at 12:47
  • 1
    Great that you solved your problem. You can answer your own question by using the button below. It's best to keep the answer in the answer section. Then you can accept it so future readers will have an easier time finding what you found out. Commented Aug 6, 2014 at 12:53

2 Answers 2

Reset to default
2

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:

  1. Right click on the edmx file, select Open with, XML editor
  2. Remove the DefiningQuery entirely
  3. Rename the store:Schema="dbo" to Schema="dbo (remove the "store:")
  4. Remove the store:Name=... property (entirely)

Note: this was moved from the question and posted on the OP's behalf.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Solved this issue by removing/commenting out the 'DefiningQuery' section in the edmx file. Didn't have to do any renaming for me.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.