Where is data when application is deployed?

[kbutchm]

Hi,I'm designing a vb.net application which is attached to a local .sdf database (SQL Server Compact database).I can publish and deploy the project using the Click-Once function available in VS2010.My problem is that I cannot locate where the data is stored when the application is deployed!?I will encounter problems if I wanted to backup the data daily or even move the application & its data to a new pc (if needed).Any help with this would be appreciated.Thanks in advance

 

[jmcilhinney]

Where is DataDirectory ?
ClickOnce Installation - Finding 'data' directory

 

[kbutchm]

I found the .sdf database buried deep in the folder system
C:\Users\...\AppData\Local\Apps\2.0\Data\AEWVPHAL.ACD\VVZL783A.9TK\...\Data\App_Data
Its hard to find but the DataDirectory points you in the right direction.
Thanks for your help