After creating a database on the end user's computer, you'll want to define its schema by adding table definitions. WiX gives us a way to execute CREATE TABLE statements within the database that we're installing. In this recipe, we will add a table definition with a few basic fields.
To create a table, add a SqlString element that specifies the CREATE TABLE SQL statement:
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">
Add a
Componentthat has itsKeyPathattribute set toyes. It should contain aSqlDatabaseelement so that a database is set up for us to add a...