Error 2062: no mapping between entity set and association set

Are entities required to be mapped to a table or can they map to a stored procedure?

I have an entity that does not map to any specific table, instead it maps to a stored proc开发者_Go百科edure.

I am getting the following error:

Schema specified is not valid. Errors: Model.msl(6,6) : error 2062: No mapping specified for instances of the EntitySet and AssociationSet in the EntityContainer HNFS_ProviderEntities.

It appears to be yes: http://msdn.microsoft.com/en-us/library/bb896279.aspx

It turns out that instead of an entity I needed to use a complex type.

In my case I'd changed the name of the EDMX file and not updated the metadata within the connection string accordingly.

The Entity Framework designer seemed OK with this, however at runtime it'd throw Error 2062.

Referring to EDMXFILENAME in the below connection string example, make sure it is correct in all three places.

<add name="Entities" connectionString="metadata=res://*/EDMXFILENAME.csdl|res://*/EDMXFILENAME.ssdl|res://*/EDMXFILENAME.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=SERVER;initial catalog=DATABASENAME;persist security info=True;user id=USER;password=PASSWORD;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />