Adding a database to a SQL Server instance

Once we have an instance of SQL Server running on the end user's computer, the next step is to add a database to it. This will give us a place to store our application's data. With WiX, we can define a new database in a declarative style rather than with an external SQL script.

Getting ready

Create a new setup project and name it NewDatabaseInstaller.

How to do it...

The following steps show how to create a new database with the SqlDatabase element:

1. Add SqlExtension to the project by right-clicking on the References node in Solution Explorer and selecting OK after navigating to Add Reference... | Browse | WixSqlExtension.dll | Add.
2. Add the SqlExtension namespace to the Wix element:

   <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"  
   xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension">

3. Add a Component element that has KeyPath set to yes:

   <ComponentGroup Id="ProductComponents" 
                   Directory...