Download Microsoft AdventureWorks Database
Usually when we start writing a new program, or just playing with LINQ, we need a database with some information on it like tables, stored procedures and some data to play with.
Microsoft offers a complete database called AdventureWorks just for that cause.
The database contains more then 50 tables, 9 stored procedures and a few views and functions.
For SQL Server 2005, you can download it from here:
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
I downloaded the AdventureWorksDB.msi and the run the following query in the SQL 2005:
1: exec sp_attach_db @dbname=N'AdventureWorks', 2: @filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', 3: @filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf' 4:
For SQL Server 2008, you can download it from this page:
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=5705