Deploying SQL Compact Edition (SDF Files) Using Setup

I have a C # .NET desktop application using SQL Compact edition as data store. The application should be used by any user on the machine, and everyone should see the same data (the data should not be different for each user).

I am wondering where should I deploy the SDF file?

  • The user's personal data folder (My Documents) means that each user will have a separate database.
  • Deploying to the same folder as the application results in vista copying the file to \ USers \ Appdata \ local \ VirtualStore \ and seems to make different copies for each user.

Where is the best place to deploy the SDF file to make sure all users view the same data?

+2


source to share


1 answer


Expand to a folder in the% ProgramData% folder, all users of the machine can access it



+2


source







All Articles