I am creating the Music Store from Jon Galloway MVC 5 book. I have reached page 87 where you execute the scaffolding template. I try to create a scaffold by right clicking on Controller file then selecting "add controller" I then select everything he tell me to however I recieve an error message telling me "Unable to retrieve for 'MvcApplication3.Models.Album'.Using the same DbcompiledModel to create contexts against different types of database servers is not supported. Instead, create a seperate DbCompiledModel for each type of server being used"

Which means I can't complete the scaffolding part of the book. Does anyone know what I need to do to correct this error? Any help would be much appreciated.

This can indicate a variety of problems with your database connection. Which version of Visual Studio are you using? In you web.config, what does you data connection look like?

There are a lot of answers on StackOverflow, depending on the specific issue you're hitting: http://stackoverflow.com/questions/1...t-working?lq=1

My connection string looks like this.

<add name="MusicStoreEntities" connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf" providerName="System.Data.SqlServerCe.4.0"/>
</connectionStrings>

Do I need to change any of it to maybe to connect to my sql express database.

Im using Visual Studio 2012

<connectionStrings>
<add name="MusicStoreEntities" connectionString= "Data Source=C:\Users\Gary\Documents\Visual Studio 2012\Projects\MvcApplication3\MvcApplication3\App_ Data\MvcMusicStore.sdf" providerName="System.Data.SqlServerCe.4.0"/>
</connectionStrings>