I noticed in the Advanced Properties of the connection string dialog, there is a setting for AttachDbFilename (see picture attached).
The question is, in this case, the file resides on the E:\ drive of my local system. When the application is finished and deployed, will my application's connection string still refer to the E:\ drive? Should I move the MDF file to the SQL data folder or can I leave it where it is and just copy the MDF file to the application's directory and the connection string will update when the application is installed?
I guess the bottom line is...do I need to worry about this or will the database attach correctly on install when the project is finished?
