No mapping specified for instances of the EntitySet and AssociationSet in the EntityContainer
When you move your Visual Studio solution to another workstation you may encounter the following error message:
System.Data.Entity.Core.MappingException was unhandled by user code
HResult=-2146232032
Message=Schema specified is not valid. Errors:
: error 2062: No mapping specified for instances of the EntitySet and AssociationSet in the EntityContainer …
Source=EntityFramework
In this case it may help if you re-import the database objects into the .edmx file.
To import all objects again:
- Open the .edmx file,
- Press the Ctrl-A keys to select all tables in the diagram,
- Press the delete key on the keyboard to delete all tables,
- Right click the white area and select Model Browser,
- In the Model Browser expand the {model name}.Store, and the Stored Procedures / Functions element
- Delete all functions and stored procedures
- In the {model name} element (the element above the {model name}.Store) expand the Function Imports element
- Delete all function imports
- Save the .edmx file
- Right click the white area of the .edmx file and select Update Model from Database
- Select all necessary tables, stored procedures, and functions and import them.
If you re-import the tables, but do not delete the stored procedures, functions, and function imports you may get the following error message:
HResult=-2146233079
Message=The function import ‘Tobacco_WebEntities.spGetAgeGroupId’ cannot be executed because it is not mapped to a store function.
Source=EntityFramework
