Move DB to DataDirectory

[FreeriderUK]

Hi all,

does anyone know how I would move my database from the .\SQLEXPRESS directory to the Application Folder ?

 

[FreeriderUK]

It's simpler than I thought.

Just add DB to project using "add existing item"
Add "AttachDbFilename=|DataDirectory|\MyDB.mdf;" to app.config connectionstring.

It seems to work...

 

[JohnH]

Data menu can be used to add new data source. You are asked if you want to add the file to project, if you confirm the connection string will point to "DataDirectory" by default.