I went through the first TRY IT OUT of Chapter 12.
Everything went fine (I think) until Step 9: "You should see the Genre and Review tables appear as shown in Figure 12-7."

Nope. Those things did not appear.

Any help appreciated. Thanks.

Can you provide more information? Currently, it's impossible to say anything about this.

For example:

1. Post your source code.
2. Up until which step does it work OK?
3. Do you see the reviews and genres in the database?
4. Does your database schema match the one from the book?

Providing detailed steps would help me help you.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Oh, never mind. I see this is a SQL Server Management Studio exercise.

Are you sure you picked the right database when you ran the scripts? Maybe you added the tables to the Master database instead? What do you see in the list of databases on the left? Does any of the databases have your tables?

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

There is no source code involved in this TRY IT OUT.

I just have to follow the steps in using SSMS to create the PlanetWroxTemp database. Everything apparently works fine except that, at the last step, my schema doesn't match the one in the book because dbo.Genre and dbo.Review do not appear (but everything else - System Tables, File Tables, Views, Synonyms, ..., etc - does).

There's a bunch of databases, e.g. master, under System Databases.
There is no sign of the Genre and Review tables anywhere.

Then you either didn't run the script or it errored somehow.

>> There's a bunch of databases, e.g. master, under System Databases.

Don't you see the PlanetWrox database from step 5?


Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Yep, the PlanetWroxTemp database is there.

I ran the script a second time and got a long list of messages starting with:

Msg 2714, Level 16, State 6, Line 1
There is already an object named 'Genre' in the database.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK_Genre'. Cannot insert duplicate key in object 'dbo.Genre'. The duplicate key value is (1).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_Genre'. Cannot insert duplicate key in object 'dbo.Genre'. The duplicate key value is (2).
The statement has been terminated.
...
...

I'm new to all this, but I think these messages suggest that the Genre and Review tables have been created and do now exist.

But they're not appearing under the 'Tables' folder.

Yep, correct. Then on the left, make sure that the PlanetWrox database is expanded and click Tables. Next, click the Refresh icon on the toolbar above the list of databases. Then expand Tables. Then you should see the Genres and PhotoAlbums tables.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

That hasn't made any difference.
Any other ideas what's going wrong?