The bottom of p. 82 indicates that if a database isn't already created, one will be created. As far as I can determine, a database wasn't created when I ran the project. Any suggestions?

Been eyeballing this section of the book for a couple weeks now. The paranoid part of me doesn't want to trudge on for fear that this will affect me later. As far as I can tell, I'm following the book directions, but they are a bit ambiguous. Not typical Wrox style directions.

I should add, I'm using VS 2012 .Net 4.5 and Entity Framework 5.

I found that this procedure does create a database but it's not immediately evident. If you go into the folder where your SQL Server databases are stored by default, you will see that the database has been created.

My problem is that I've checked the Models folder and nothing is there, supposedly where it should be.

I am hitting this issue too. I have tried doing the scaffolding over and over.

* I am using Visual Studio Pro 2010 with its MVC 4 add-on.
* Also, I am using the local dev database instead of the local IIS database.
* I did not put the connection string in the web.config since the book said it would do it itself.

Anyway, I have created the Album.cs, Artist.cs, and Genre.cs classes. I have then run the scaffolding as the book states. After it runs, I see the views, controller, and the MusicStoreDBContext.cs in the Models folder.

However, when I navigate to the storemanager page, I see no changes to my project. If I check the Server Explorer > Data Connections, I do not see any new database even after clicking Refresh.

I have rebuilt the project.

I have confirmed that the web.config file has this connection string:
<add name="MusicStoreDBContext" connectionString="Data Source=.\SQLEXPRESS; Initial Catalog=MusicStoreDBContext-20130530204601; Integrated Security=True; MultipleActiveResultSets=True"
providerName="System.Data.SqlClient" />

Still I am not seeing evidence of a database created.


** This creates a problem because when I create the MusicStoreDBInitializer class (in the Models folder), I get a error:
"The type or namespace name 'MusicStoreDB' could not be found (are you missing a using directive or an assembly reference?)"

- With that said, I notice that the DropCreateDatabaseAlways takes a context.
I get the error above with this code (which is from the book):
I do NOT get that error with this code
I notice that the text says "Name your context MusicStoreDB" but the screenshot has "MusicStoreDBContext" in the New Data Context window's field.

So, I am assuming I should use DropCreateDatabaseAlways<MusicStoreDBContext> since the file name in my Models folder is MusicStoreDBContext.cs, but I am still wondering why I am not seeing a database.

Is it possible I am looking in the wrong spot?
Is it possible I have some windows permission issue it is not throwing a flag/error about?

Okay, I have confirmed that I should be looking in the App Data folder for the database and should also see it in the Server Explorer. Please let me know if anyone finds reasons the databases are not generating as expected. I believe you could do this with MVC 3 even; so, I don't think it is the fact that I am using Visual Studio 2010 with MVC 4, but maybe it is...

Hello all,
It looks like in my case, there are a couple of things to note.

1. the database created. It is just not visible in my VS 2010 Server Explorer. It is visible in the Database Explorer when I load the project in VS 2012 Express. I now have to figure out why my VS Pro 2010 does not show it.
2. I put the DBInitializer class in the Models folder because the MVC Music Store tutorial on asp.net website puts it there. So, my code in global.asax.cs to properly seed the database needed to look like this below, which is a little different from the book.
   
   Code:

    Database.SetInitializer(new Models.MusicStoreDBInitializer());

3. The book is confusing since the text does not match (as discussed above) between MusicStoreDB in the text and MusicStoreDBContext in the screenshot. I have confirmed that if you used MusicStoreDBContext like the screenshot, that is what you need to use in your code.
   So, like this in your DBInitializer class
   
   Code:

        public class MusicStoreDBInitializer : DropCreateDatabaseAlways<MusicStoreDBContext>
       {
           protected override void Seed(MusicStoreDBContext context)

Well, in case anyone else hits the issue I hit, the solution for me is:

use Visual Studio 2012 Express

• I found this page which I thought was going to fix my issue
  http://stackoverflow.com/questions/1...erver-explorer
  I found 2 things with this

  • I had to right click on VS Pro 2010 and click Run As Administrator to do what he did
  • When I did this I could connect to the database in Server Explorer OR my local dev server could connect to it. So, I could not use the server explorer and the local dev server at the same time. When I tried, one would connect and the other would throw an error saying it could not connect to the db because another process was already using it.

• I have also found this page, which indicates maybe I'd need to reinstall VS 2010 Pro as maybe some permission got corrupted
  http://social.msdn.microsoft.com/For...-0680f686da8c/
  but I am not certain that what that person hit is what I am encountering

Anyway, things operate fine when working with the local dev server and the database explorer at the same time in VS 2012 Express. So, my solution is just to use VS 2012 Express instead.

If anyone has suggestions on things to check/try to get VS Pro 2010 working with this project, let me know. I do prefer VS 2010.

I tried it but this data not working properly can you tell me other alternative solution??

I agree that this chapter could have been a little clearer on some items. The database doesn't show up in the Server Explorer or in the App_Data folder. I found that it was created on my computer by going to C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL; and I am also able to open and manipulate the database with the SQL Server Management Studio.