Switch Connectionstring to Appdata/Roaming

Question

My application installed the database . mdf in Appdata/Roaming. Now I probably need to change my path from ConnectionString to this place. How do I do it?

I read online about using Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)

But where do I type this? In the Form1.cs where all the code is?

In the archive app.config has this code line:

connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\DatabaseIris.mdf;Integrated Security=True"

Answer 1

Change relative path (recommended):

    ConnectionString = "Data Source=|DataDirectory|\Database.sdf";

Change at runtime according to executable:

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

Source: https://stackoverflow.com/questions/1833640/connection-string-with-relative-path-to-the-database-file