View source for Set DataDirectory manually

[[Category:Database]]
[[Category:SQL]]
[[Category:CSharp]]

In windows applications, 

You can manually set your DataDirectory by using '''AppDomain.CurrentDomain.SetData("DataDirectory", path)'''. 

You can get the path of your executable by using AppDomain.CurrentDomain.BaseDirectory


=== Connection String === 
 Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\LocalDbVisTest.mdf;Integrated Security=True
-----------------------

=== Relative path: ===

        ConnectionString = "Data Source=|DataDirectory|\Database.sdf";
=== Modifying DataDirectory as executable's path: ===

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