Database connection from WPF

Question

I have a folder 'Data' in my WPF application in which there is an .sdf database file. This file is the database for my application.

When developing my app I used a fixed path to my db like this:

'Data Source=P:\Dropbox\Projects\MembersApp\MembersApp\bin\Debug\Data\RF_db.sdf'

Now I want to use the |DataDirectory| value so that the app always can find the db, were ever the app is installed. I found this solution on StackOverflow:

string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;
string path = (System.IO.Path.GetDirectoryName(executable));
AppDomain.CurrentDomain.SetData("DataDirectory", path);
string dataSourceHome = "Data Source=|DataDirectory|\RF_db.sdf";

But is giving me an error on the last line 'Bad compile constant value'. I've tried with:

string dataSourceHome = @"Data Source=|DataDirectory|\RF_db.sdf";

But that doesn't work.

Any idea what's wrong here?

I found this solution here [StackOverflow][1] which works for me. Just needed to rename my 'Data' folder to 'App_Data' and use this code: string data = @"Data Source=App_Data\RF_db.sdf"; LocalConnection = new SqlCeConnection(data); This works for me when I run my app localy. However when I deploy my app with clickonce it fails. [1]: stackoverflow.com/questions/12932963/… — PitAttack76
– PitAttack76, Commented Dec 29, 2012 at 22:07

Dour High Arch · Accepted Answer · 2013-01-03 17:10:51Z

1

Do not change DataDirectory in your code; it is set by the installer and changing it will prevent your app from knowing where the data was installed. Just use:

string dataSourceHome = @"Data Source=|DataDirectory|\RF_db.sdf";

And nothing else. Do not call AppDomain.CurrentDomain.SetData("DataDirectory", path); that's what is breaking things.

edited Jan 3, 2013 at 17:10

answered Dec 30, 2012 at 2:49

Dour High Arch

21.8k31 gold badges78 silver badges93 bronze badges

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

Comments

sa_ddam213 · Accepted Answer · 2012-12-29 21:32:17Z

1

You could use:

string dataSourceHome = string.Format("Data Source={0}\\RF_db.sdf", Environment.CurrentDirectory);

or

 string dataSourceHome = string.Format("Data Source={0}\\RF_db.sdf", System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location));

answered Dec 29, 2012 at 21:32

sa_ddam213

43.7k7 gold badges106 silver badges112 bronze badges

1 Comment

Dour High Arch Over a year ago

If he is using an installer or ClickOnce the data directory may not be the application nor the assembly directory. In fact, from his edit it appears it is not.

Community · Accepted Answer · 2017-05-23 11:43:06Z

0

It looks like your creating a ADO.Net connection string. Isn't there just information missing from your dataSourceHome? Have a look at this post.

Or a different approach to creating the connection might be found on ConnectionStrings.com.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Dec 29, 2012 at 21:14

Jacco

3,2721 gold badge22 silver badges30 bronze badges

Collectives™ on Stack Overflow

Database connection from WPF

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related