Database Design, "Migrate to SQL Server 2005 Express Edition," by Roger Jennings
Visual Studio Magazine, July 2005

README FILE FOR THE SQLEXPRESS.SLN AND AWORDERSANDDETAILS.SLN SAMPLE PROJECTS

Create separate folders for the two projects and unzip the contents of SQLExpress.sln and AWOrdersAndDetails.sln into them. (Be sure that the Use Folder Names check box is marked.) 

Building and running the projects requires February CTP or later builds of VS 2005 or VB Express 2005, and SQL Server 2005 or SQL Express 2005. AWOrdersAndDetails.sln requires installing the AdventureWorks OLTP database by running the instawdb.sql script.

The connection string for both projects specifies .\SQLEXPRESS as the instance name. If you're using SQL Server 2005, change .\SQLEXPRESS to (local) or localhost.

See http://www.oakleaf.ws/sampledbs/ for illustrated sample database download and installation instructions.

--------------

SQLExpress.sln

This project demonstrates use of temporarily attached (detachable) .mdf and .ldf with SQL Express for XCopy and Windows Installer deployment. Note the number of copies of database files for projects with Debug and Release versions. The northwnd.mdf data and log files are included with the project. Tables are updatable, but no code has been added to enforce referential integrity for updates, inserts, or deletions.

The project also demonstrates the current state of VS 2005's "codeless" data access forms.

----------------------

AWOrdersAndDetails.sln

This project demonstrates issues with AdventureWorks as a sample database for ADO.NET 2.0 books and articles. Although SQL Server 2005 Books Online favors AW as the sample database, most VS 2005 data-binding examples continue to use Northwind. AW is over-normalized and excessively complex to demonstrate basic database front-end techniques. For a longer discussion of this issue, go to http://oakleafblog.blogspot.com.

Code behind the form and DataSet designer code has been modified to accommodate computed columns of the SalesOrderHeader and SalesOrderDetail tables, and the rowguid column of the SalesOrderDetail table.

As noted above, AWOrdersAndDetails.sln requires installing the AdventureWorks sample database before the project will run.
