How do I map my connection string to my app_data folder rather than use an absolute path?

Question

I have a connection string that includes the absolute path to my database.

Here's my connection string:

// removed

I have 2 questions:

How do I convert the absolute path to look at my app_data folder instead of adding a full string?
Is this a good /bad thing to do?

Thanks in advance.

Rajeev Bera · Accepted Answer · 2013-07-11 14:37:35Z

1

You should be able to use the |DataDirectory| substitution string:

AttachDbFilename=|DataDirectory|MyDb.mdf

Rajeev Bera

2,0191 gold badge16 silver badges30 bronze badges

answered Mar 27, 2013 at 11:43

Richard Deeming

31.5k11 gold badges86 silver badges167 bronze badges

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

1 Answer 1