It has a DefiningQuery but no InsertFunction element... err

user_79456 0
Viewed 70891

This thing is driving me crazy, and the error is quite meaningless to me:

Unable to update the EntitySet 'TableB' because it has a DefiningQuery and no element exists in the element to support the current operation.

My tables are put like this:

TableA
int idA (identity, primary key)
...

TableB
int idA (FK for TableA.idA)
int val

TableB has no defined primary key in the SQL server. The Entity Framework has imported the table and the association and set both fields as key. But it will output that error when I try to do an insert into the table!

What's wrong??

Edit: As suggested by Alex, the solution was this:

  1. Right click on the edmx file, select Open with, XML editor
  2. Locate the entity in the edmx:StorageModels element
  3. Remove the DefiningQuery entirely
  4. Rename the store:Schema="dbo" to Schema="dbo" (otherwise, the code will generate an error saying the name is invalid)
  5. Remove the store:Name property

I left the key as it was, since it was OK to me that both the columns are part of the key.

entity-framework asp.net
6 Answers
  1. You need to manually open the .EDMX file in notepad or notepad++ or in any text editor of your choice.
  2. Locate the entry in edmx:StorageModels in file opened in step1.
  3. Find the DefiningQuery element and remove this tag entirely.
  4. Find the store:Schema="dbo" to Schema="dbo" (if you skip this step it will generate error of the name is invalid).
  5. Save and close the file.

Hope it will solve the problem.

user_92034340
Related