Installing a SQL Server database

In some samples of the book, we use a SQL Server database. To install a SQL Server database, we can either attach the SQL Server MDF file to SQL Server or execute a SQL query file that contains the commands to create the database, its tables, and its columns.

Attaching an MDF file

The simplest way to install a database is attaching the database into the SQL Server instance. To do so, follow the given steps:

  1. Open SQL Server Management Studio and connect to the database engine (most of the time, this instance is called localhost).
  2. Within the Object Explorer, right-click on the Databases node and select Attach.
  3. In the Attach Databases dialog, click on the Add button and browse to the location of the MDF file that contains ...

Get Silverlight 4 Data and Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial