Either the parameter @objname is ambiguous or the claimed @objtype (column) is wrong.

Question

Problem :

I am having the table with the name EducationTypes and also an Entity named as EducationType, I just tried to rename the one of the entity properties but now I am always facing following error :

Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. How can I fix the above mentioned error?

The generated SQL Script is as below:

EXECUTE sp_rename @objname = N'dbo.EducationTypes.nvarchar', @newname = N'EducationTypeTitle', @objtype = N'COLUMN'

Answer 1

I think this is happening because of the name Conflict of Class (Model) names with the other reserved or the generated ones, but when auto creates the tables and Considering that EF Code First creates the intervene tables to relate the two or more of the tables using name of the tables for derived intervene table, so when you use the class name that employs a name like the intervene tables, we will get as such this ambiguous error.

e.g. If you have the Question class which has the navigation property with the name Answer  then the internal model metadata will contain the reference called QUESTION_ANSWER

To resolve this, just try to change the class names which are used for generating tables and ensure that they are unique.