Databases Reference
In-Depth Information
FIGURE 1.4
Data model templates.
The data model includes some or all tables in a single database, so when naming the data
model file, it is a good idea to use the name of the database it will represent. In this topic,
Northwind sample database is used, and the entity data model file is
Northwind.edmx
.
NOTE
The Northwind sample database for SQL Server is available for download from
Microsoft at the following address:
Originally developed for SQL Server 2000, it works with versions 2005 and 2008.
The installation program, SQL2000SampleDb.msi, extracts the database files and
scripts in the “C:\SQL Server 2000 Sample Databases” directory on your computer.
You can create the Nor thwi nd dat abase by r unning the following comman ds in the
Command Prompt window:
c:
cd “SQL Server 2000 Sample Databases”
sqlcmd -S .\sqlexpress -E -i instnwnd.sql
Note that in this example,
-S .\sqlexpress
refers to a local installation of the
Express edition of SQL Server. If you have a default installation of the Developer or
another edition on your computer, you need to change this parameter to
.
or specify
the actual name your SQL Server.