I am trying to get the MVC Music Store application to work with SQL Server Express.
This task is proving far trickier than PHP / MySQL.
I am running Windows XP SP3, SQL Server Express 2008 with Management Studio (no SP)
and Visual Studio Express 2010 with MVC 3.0 (no SP but hotfixes and updates applied)
I have downloaded and unzipped MvcMusicStore-v3.0.zip
I do not want SQL Server compact edition.
To my way of thinking I should be able to
1) attach the MvcMusicStore.mdf in the assets folder to SQL Express
2) copy the MvcMusicStore.mdf file to the App_Data folder and 'include in project'
modify the connection string in the web.config to point to either database
Failing either the above I should be able to in SQL Express create a new database
called MvcMusicStore and then run the MvcMusicStore-Create.sql file found in the
Assets/Data folder to populate the database.
Again, modify the web.config file to point to this database and off we go.
There maybe an additional step where I give the ASPNET account permissions
in SQL Server or configure Integrated Security.
After trying various combinations of the above I have failed to get the application to work.
Error messages include
'Model compatibility cannot be checked because the database does not contain model metadata.'
The databse does not look complicated as far as I can see there are only 6 tables and no stored
A search on this site and ASP.Net and Google has not provided a simple, straightforward answer.
Apart from not using PHP/MySQL what else am I doing wrong?
Thanks for your patience