Chapter 3 page 64 it wants you to type aspnet_regsql.exe -E -S .\SqlExpress -daspnetdb -t customers -et

but i do not have a customers table, i don't even have a tbh_Customers table. Is there something i may have missed? Should I add this table manually?

No don't add the table manually. The instructions given on page 64 are not given for the "solution" rather they are given as part of an overall discussion on SQL Dependency in planning the architecture of the the Web Site.

If you want to create the database for the solution using SqlExpress then you can do everything from within VS 2005.

I'm confused does chapter 3 page 64 give instructions for creting the database? The text makes out like this is part of the project. If it is not then shall I just carry on adding the following code or is this just an example as well. Basically could someone tell me if chapter three requires any actual implementation or is it all theoretical?

Thanks for your help!

Hi FuriousOrange,

I almost posted this same question when I realized my own mistake. Basically, you do not need to do this. Almost everything in the design sections are just FYI. While he talks like you should do it, he's just explaining how you would do it if you were to, not necessary for the Beer Store itself. So just skip it.

Hey, that's good to know. I was also struggling with getting those sql commands to run properly. I was trying to turn on caching using the sql commands shown, but just received an error message from my sql server 2005 express. The error message said something about not managing to log in. Furthermore, it said something about maybe remote connections was turned off (which it was, but it didn't work after I enabled it either).

I am having big problems running queries using the SQL Server Management Studio Express. For some reason, I get an unhandled exception when I right-click any database, and select New Query. Really frustrating. Has anyone else experienced the same, or similar problems with the Management Studio? I thought the error message mentioned earlier (while trying to enable caching) happened due to these problems with Management Studio, but now I suspect that these are not related, since we're not supposed to do every little thing that is being mentioned in the Design section of the text.

I'll try to get on with my life now (and the book) :)

--------
Wisdom on the internet? How rare!