Hi all,

I have sql server 2005 installed. I am using Visual Studio 2008.
Page 14 goes into creating s sql server express database.

Does anyone know how to connect to sql server 2005.

I would still do as taught at page 14. After having created the NerdDinner.mdf file, I will then open SQL management studio, right-click on Databases and select Attach...

From the dialog, I will point to my NerdDinner.mdf file. If you cannot point to the correct location (for some reason, I could point at my computers Documents folder?!), then find the correct path/filename in Explorer and paste the whole path/filename into the dialog. Then it will attach.

I'm not sure if this will cause other problems, but I don't think so :-)

I just created the database in SQL Server management Studio and connected to it with Server Explorer. It appars that the steps on page 14 are for Sql Express only.

Thanks,

Kermit

From Ole F: "I would still do as taught at page 14. After having created the NerdDinner.mdf file, I will then open SQL management studio, right-click on Databases and select Attach..."

The problem is that I cannot create the NerdDinner.mdf file as taught on page 14. On attempting to follow the directions an error message says that I must have SQL Express.


I have an insatnce of Sql Server 2005 developer. I have no instance of Sql Express.


I created the NerdDinner database and the tables and relationships using SQL management studio. I then used VS Server explorer to connect to the data base.

I am having trouble with the publicclassDinnerRepositoryThe example in the book has no using statementsIn one part of the books code:

publicIQueryable<Dinner> FindUpcomingDinners() {
return from dinner in entities.Dinners
where dinner.EventDate > DateTime.Now
orderby dinner.EventDate select dinner;
}

The DateTime object was not recognized until I added "using System;" above the class declaration.

I will probably need to add all appropriate namespaces for the code to work like System.Linq.

In an enterprise application there will be no Sql Express.

Do anyone know how to use Sql Server 2008 for the exercises in the book.

Thanks in advance for any assistance.

-Kermit

My suggestion is that since there are so many errors in the tutorial, I would download a free SQL Express.

A lot of the other errors are corrected in the forum (search for "errata") and there is no need to complicate the tutorial further!

Download the free edition here: http://www.microsoft.com/sqlserver/2...us/try-it.aspx. The third option is the one you want.

I would agree. Trust me, use SQL Express for the moment. You'll need to get other hurdles (and there are many) as you work through Nerd Dinner. Fortunately, most have been addressed in these forums.

I took all the errata I got and used from these forums to reported it to Wrox. Hopefully they will update the official errata.

I am moving on. Thanks for the input.