C# WPF with SQLite Database Publishing in Visual Studio 2010

I have developed an application in C# using WPF. I want to publish the software to my website so users can download the installer and it will automatically update when I release a new version.

I am having a couple of problems with the publishing of the project.

First of all, the software is using an embedded SQLite Database. When I run the installer from the website, it downloads fine but does not include the database file that the software needs. How can I include the database file in to the installer.

The second problem 开发者_C百科is how to choose where the program installs to on the users PC. When I installed it I expected it would install to C:\Program Files\Company Name\Project Name but it doesn't put it there. How can I do this as well.

Thanks for any help you can provide with this.

---

1. include your db file into project and restore db from it when application start
2. you are using clickonce, so you deal with sandbox application/ So you have 2 options - do not use clickonce (google for dday project for example or use windows installer) or use clickonce paths to found your files (take a look)