ASP.NET 2.0 Club Web Site Starter Kit

I just watched the last part of the live webcast from the Visual Studio 2005 Launch Event in San Francisco. Steve Ballmer introduced Brian Goldfarb who in turn introduced a student who showed off the Club Web Site Starter Kit for ASP.NET 2.0. Microsoft's own code analysis tool wasn't very impressed with the Personal Web Site Starter Kit. Maybe, this one would do better.

On the ASP.NET website I found the download location for the Club Web Site Starter Kit. The download link send me a .vsi file. Opening the file gave me a short wizard to add a new web site template to Visual Studio 2005 (for both C# and VB.NET). I created a new web site using the new template. This web application compiled without errors. So far so good. 

But running code analysis on the C# gave a horrific number of 190 warnings.

Then I tried to run the site. No luck there, since SQL Server 2005 Express Edition refused to attach to the clubsite.mdf database that ships in the App_Data folder. The error was:

"Database 'P:DOCUMENTS AND SETTINGSERWYNMY DOCUMENTSVISUAL STUDIO 2005WEBSITESCLUB WEB SITE STARTER KITAPP_DATACLUBSITE.MDF' cannot be upgraded because its non-release version (600) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database."

Poor timing on Microsoft's part: If you hype a starter kit at the launch event, you better make available a version that runs on the RTM version of SQL Server 2005! It's not as if Microsoft didn't know about this problem far in advance. A couple of ASP.NET forum posts show that people have been jumping through hoops since September 26, 2005 to get the database to work on the Release Candidate.

Here are the steps to follow to get the starter kit working if you have both SQL Server 2005 Developer and Express Edition installed:

  • Download the SQL script (packaged as an executable) that can create the tables and stored procedures.
  • In the SQL Server Management Studio connect to a Developer Edition or Express Edition instance and create a new empty database named clubsite.
  • Open the SQL Script in SQL Server Management Studio and run it against the clubsite database.
  • Detach the database by rightclicking on the database node, choosing Tasks | Detach.
  • Move the clubsite.mdf over the App_Data folder of the ASP.NET web application.
  • Run the web application.

[Update 2006-01-26: Microsoft has posted a new version of the Club Web Site Starter Kit that runs without modification on the RTM version of SQL Server Express. You can download it from here. It was digitally signed by Microsoft on January 12, 2006.]

One thought on “ASP.NET 2.0 Club Web Site Starter Kit

Leave a Reply

Your email address will not be published. Required fields are marked *