|DataDirectory| in Project properties > Settings

Question

The connection string setting is below:

Name: dbPersonConnectionString

Type: Connection string Scope: Application

Value: Data Source=|DataDirectory|\dbPerson.sdf

When I install & run the application, it looks for DB in C:\MyApp\Data\ folder. It should be C:\MyApp without additional \Data folder.

Should I simply create Data folder in my project and move DB files under that folder or I simply adjust |DataDirectory| -and how-?

EDIT:

        string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;
        string path = (System.IO.Path.GetDirectoryName(executable));
        AppDomain.CurrentDomain.SetData("DataDirectory",path);

That explains the changed default. Maybe just go with the flow. — Henk Holterman, Jul 27 '11 at 11:56

score 6 · Accepted Answer · answered Jul 27 '11 at 11:49

6

This has been asked before. This MSDN post gives a good overview.

It should indeed default to your binaries folder, you can change it with AppDomain.SetData() . If you change it, better do it early.

answered Jul 27 '11 at 11:49

Henk Holterman

250,905
30
306
490

1

An SO answer: http://stackoverflow.com/questions/1409358/ado-net-datadirectory-where-is-this-documented/1409378#1409378 – Henk Holterman Jul 27 '11 at 11:50

score 5 · Answer 2 · answered Jan 02 '15 at 04:22

5

AppDomain.CurrentDomain.SetData("DataDirectory", Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location));

This should work always because Directory.GetCurrentDirectory() may return other directory than the executable one

answered Jan 02 '15 at 04:22

Memo

321
3
4

where this code should be placed in my winform app? – Mubsher Mughal Jul 02 '18 at 06:54

score 1 · Answer 3 · edited Dec 06 '13 at 16:31

1

This one solved my problem

AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory());

edited Dec 06 '13 at 16:31

kleopatra

50,242
28
96
201

answered Dec 06 '13 at 16:22

Ashutosh

3,945
9
53
92

|DataDirectory| in Project properties > Settings

3 Answers3

Linked