ClickOnce deletes my local database when it updates.. how not to?

I'm using ClickOnce to deploy my application. When the ap开发者_运维百科p runs the first time, if a db doesn't exist, it creates one.

Problem is, when I update, it removes the local database. Is there a way to tell it to ignore it?

I imagine you're putting it in the applications directory... don't!

Put it in Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData or Environment.SpecialFolder.LocalApplicationData).

Don't include the database in the deployment. Implement your own db creation (using script) when the database isn't present.

In the project's Publish options, under Application Files, is the database file's Publish status set to Data File?