Error 2062: no mapping between entity set and association set

Question

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 procedure.

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.

Wagshul

Answer 1

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.

Wagshul

Answer 2

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" />

Restate

This doesn't answer the question. Having the same error isn't relevant. – Decentralization