Unable to retrieve metadata for 'MusicStore.Models.Album'. Using the same DbCompiledModel to create context against different types of database servers is not supported. Instead, create a separate DbCompiledModel for each type of server being used.

You will get this error in the step by step tutorial (on page here) provided by Microsoft that starts from here.

If you look in your solution you will find 'SQL Server CE' database is being used and to which the application was somehow unable to connect and thus this message comes up.

Once you update the connectionString to use a regular 'SQL Server' database will fix this titled issue.

How to fix?

In Part 4 of this step by step turorial, you probably have added following code in you connectionString:

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

Now, delete above chunk of codes and run the application and try to navigate to ‘Store’ controller, this will automatically create the new and regular ‘SQL Server’ Database for your project and will also seed some dummy data from a file ‘SampleData.cs’, you will find this in ‘Model’ folder.

And now, you are ready to go further in that step by step tutorial.

I hope this fix will help you. Thanks.

Comments

  1. AnonymousFriday, October 26, 2012 9:08:00 am

    i too got this error....thank u very much ur solution helped me in fixing it

    ReplyDelete
  2. AnonymousThursday, November 08, 2012 5:09:00 am

    Thanks for your post

    ReplyDelete
  3. AnonymousMonday, December 10, 2012 6:21:00 am

    Thanks for your helping

    ReplyDelete
  4. mahadevThursday, December 13, 2012 8:28:00 am

    thanks alot...but one thing that i have noticed is you will need that code which have been deleted after the database has been added. so i think you should better keep it safe and put it later in config file again.

    ReplyDelete
  5. UnknownMonday, March 11, 2013 1:50:00 am

    That worked. Thank you sir!

    ReplyDelete
  6. AnonymousMonday, April 01, 2013 10:12:00 pm

    Thanks a lot bro...... It will work

    ReplyDelete
  7. AnonymousFriday, April 12, 2013 7:19:00 am

    A lot new information found until found this topic. Thanks a lot.

    ReplyDelete
  8. AnonymousThursday, April 18, 2013 3:09:00 am

    very useful, thanks so much!

    ReplyDelete
  9. VWednesday, May 01, 2013 9:30:00 am

    It worked. Thank for sharing.

    ReplyDelete
  10. AnonymousWednesday, June 26, 2013 12:04:00 am

    Thanks

    ReplyDelete
  11. AnonymousSaturday, July 06, 2013 3:52:00 am

    it helped me..thanku

    ReplyDelete
  12. AnonymousSaturday, October 05, 2013 1:23:00 pm

    YES..Absolutely do not change ANYTHING, at all, in anyway in the web.config files contents and everything works great..must of course add the new controller's name to the http:\\localxxx\newcontrollersname call.

    ReplyDelete
  13. AnonymousSaturday, October 05, 2013 2:57:00 pm

    The "DefautlConnection" that comes with the MVC autobuild does not create a db but works with a log file to create the movies.
    This code worked for me creating .mdf and .ldf files in the App_Data folder under the project files.….now will that translate to SQL on hosting web???

    <add name="MovieDBContext"
    connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=MVCSqlTest;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\MVCSqlTest.mdf"
    providerName="System.Data.SqlClient"

    ReplyDelete
  14. UnknownMonday, October 21, 2013 11:35:00 pm

    Thanks Abhi, it's working for me. :)

    ReplyDelete
  15. AnonymousTuesday, April 29, 2014 5:07:00 am

    Thank you man , it works

    ReplyDelete
  16. AnonymousFriday, June 13, 2014 1:22:00 am

    Works!

    ReplyDelete
  17. SreeramuluMonday, June 23, 2014 8:00:00 am

    Thanks Abhimanyu !!! Your suggestion resolved the issue.

    ReplyDelete
  18. UnknownFriday, August 15, 2014 9:58:00 pm

    It works.. thanks...

    ReplyDelete
  19. arfanTuesday, June 16, 2015 3:43:00 am

    Uninstalling Entity Framework 6.0 and Installing Entity Framework 5.0 solved this error.

    In NuGet Package Manager Console I ran below command to solve this issue.

    Uninstall Entity Framework 6.0 using below command:

    UnInstall-Package EntityFramework.SqlServerCompact UnInstall-Package EntityFramework

    Then install Entity Framework 5.0 using below :

    Install-Package EntityFramework -Version 5.0.0

    Install-Package EntityFramework.SqlServerCompact -Version 4.3.6

    ReplyDelete

Post a Comment

Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Image
As you know ASP.NET Core Identity (table structure) is different from what we had earlier in ASP.NET Identity. Actually the identity system which we have today with .NET Core is very mature and continuously evolved be it ASP.NET Membership, ASP.NET Identity 1, ASP.NET Identity 2 and now ASP.NET Core Identity. Recently I had to migrate few application to ASP.NET Core and similar its identity database. Because the table schema is changed, i had to re-think and create migration script which I would like to share with you today. It is very simple and easy, just three step and I had everything ready: STEP 1 : Change name of existing tables STEP 2 : Create ASP.NET Core Identity tables STEP 3 : Migrate data from old tables (ASP.NET Identity) to new tables (ASP.NET Core Identity) Script:  https://gist.github.com/itorian/c699e8534b392a6c726ec66c48100072 You should also watch my video, where I demoed migration.
Read More »

Customize User's Profile in ASP.NET Identity System

Image
Note: You should read this post instead, I found below walkthrough will not work on ASP.NET Identity 2. I will re-work on this post soon. In this post you will learn how to customize User’s Profile and add some more fields like FirstName, LastName, EmailID etc with ASP.NET Identity System. In my last post I listed some of the great new features introduced with Identity system .
Read More »