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
sql-server-ce deployment setup-project


source to share


1 answer


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



+2


source to share







All Articles
Loading...
X
Show
Funny
Dev
Pics