How to deploy an SQL Compact Edition database file (.sdf) in the AppData folder? Connection string?

Question

I'm planning to deploy my DB file in the Users\CurrentUserName\AppData folder, because default User Account Control settings restrict write access to the Program Files directory where my program is installed.
First question - is this correct?

So far, I've created a custom folder, set the DefaultLocation property to [LocalAppDataFolder][ProductName], and put the .sdf file in that folder.
This works in Windows 7, but it doesn't seem to work in Windows XP - I can't find any sign of it being deployed anywhere.

So where and how should I deploy the DB file?

I'm also unsure how to set the connection string to the [LocalAppDataFolder] location - any suggestions?

Edit: The application is a WinForms application which will be downloaded from a website and installed using the installer created with Setup Project.

What kind of app is it?? ASP.NET ? Winforms? Console? Service? — marc_s
– marc_s, Commented Nov 29, 2010 at 15:55

ErikEJ · Accepted Answer · 2010-11-30 11:16:14Z

3

This works for me:

string fileName = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "SqlCe35AddinStore.sdf");

string connString = string.Format("Data Source={0};", fileName);

answered Nov 30, 2010 at 11:16

ErikEJ

42.1k5 gold badges82 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lucian Over a year ago

Thanks a lot. It really helped. So, in your opinion, AppData folder is the one in which to save the database file? Again, thanks for the idea.

Collectives™ on Stack Overflow

How to deploy an SQL Compact Edition database file (.sdf) in the AppData folder? Connection string?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related