Deployment of SQL compact Edition (SDF files) using Setup project

Posted by Emad on Stack Overflow See other posts from Stack Overflow or by Emad
Published on 2009-08-27T13:42:30Z Indexed on 2010/04/01 23:03 UTC
Read the original article Hit count: 593

Filed under:

sqlce

|

deployment

|

setup-project

Hi, 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 all should be seeing the same data ( data should not different per user).

I am wondering where should I deploy the SDF file?

User's Personal data folder (My Documents) means each user will have a separate database.
Deploying on the same folder as the application causes vista to copy the file to \USers\Appdata\local\VirtualStore\ and it seems to make different copies for each user.

Where is it best to deploy the SDF file to ensure all users are looking at the same data?

© Stack Overflow or respective owner

Related posts about sqlce

Importing Excel to SQLCE

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table in excel format (2007 but I can save as anything below that, naturally), and I have an SQL Compact Edition 3.5 SP1 Database table with corresponding columns. I simply want to populate the SQLCE table with the data from the excel file. The data consists of strings and integers only. I… >>> More
Creating and Indexing Email Database using SqlCe

as seen on Stack Overflow - Search for 'Stack Overflow'
I am creating a simple email client program. I am using MS SqlCe as a storage of emails. The database schema for storing the message is as follows: StorageId int IDENTITY NOT NULL PRIMARY KEY, FolderName nvarchar(255) NOT NULL, MessageId nvarchar(3999) NOT NULL, MessageDate datetime NOT NULL, StorageData… >>> More
sdf file (sqlce) not copying to emulator

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with copying sdf file to WM emulator. My solution structure MyApp.DataLayer - there is sdf file MyApp.WMUI - this is windows mobile winform app sdf file has set build action: content copy to output directory: copy always But if I deploy app to emulator, that sdf file doesn't… >>> More
SqlCe Connection count

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to determine the number of connections say a windows application has open with SqlCe? >>> More
How to check if sqlCE is installed on Windows CE

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I check if sqlCE is installed on Windows CE (in C#)? >>> More

Related posts about deployment

ClickOnce manifest problem

as seen on Stack Overflow - Search for 'Stack Overflow'
We are currently deploying a WPF 4 app via click once and there is a scenario when the installation fails. If the user does not have .Net 4.0 Full install and attempts to install our app the framework installs fine but the app fails to install. If we re-run the installation again the app installs… >>> More
Creating block devices for openstack deployment using MAAS and juju (nova-volume deployment)

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Hi, I'm currently trying to get a openstack deployment working by using MAAS with 9 nodes and juju. To do this I found this guide, working with ubuntu 12.04 LTS https://help.ubuntu.com/community/UbuntuCloudInfrastructure and followed it as good as I can. After a vigorous amount of trial and error… >>> More
Error launching application after ClickOnce deployment - "An application for this deployment is alre

as seen on Stack Overflow - Search for 'Stack Overflow'
As part of my continuous integration build the application is deployed as a ClickOnce application. This works great the first time, but when I try the launch the app after an update has been deployed I get the following error. An application for this deployment is already installed with a different … >>> More
JBoss 7.1.1 + Spring 3.1 + JPA 2 (Hibernate 3.6.8) > Cannot parse beans.xml

as seen on Stack Overflow - Search for 'Stack Overflow'
Trying to deploy a JSF 2 app with Spring 3.1 + JPA 2 (Hibernte 3.6.8) into JBoss 7.1.1 AS. The app was working fine on tomcat 7. Now, I have already added and changed some configurations. Added jboss-deployment-structure.xml <jboss-deployment-structure xmlns="urn:jboss:deployment-structure:1… >>> More
Disable Java Hardware Acceleration in windows?

as seen on Super User - Search for 'Super User'
I have some issues with my graphics card and I want to disable Hardware Acceleration for java apps. Everything that uses HA is displayed blurry. I've seen some tutorials on how to set this parameter -Dsun.java2d.d3d=false The problem is that the Java Control panel itself is using hardware acceleration… >>> More