During the installation, you may decide to populate your database tables with some seed data. For example, you may have a list of U.S. states in which you do business that you'd like to add as static data. In this recipe, we will create a database, add a table to it, and then insert new rows into that table.
Include an INSERT statements in a SqlScript element to add rows of data to a database. The following steps show how to do it.
Add
SqlExtensionto the project by right-clicking on the References node in Solution Explorer and selecting OK after navigating to Add Reference... | Browse | WixSqlExtension.dll | Add.Add the
SqlExtensionnamespace to theWixelement:<Wix xmlns="http://schemas.microsoft.com/wix/2006/wi" xmlns:sql="http://schemas.microsoft.com/wix/SqlExtension">
We're going to store all our SQL commands in a file. So, use Notepad to create a file...