C# - Know location of database file dynamically

Question

I am making a program using C# in WPF, and I need to access the database dynamically, in this case I am using a .mdf.file. In code I have connectionString like this:

string stringConexao = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=E:\PAP\Trabalhos\Trabalhos\Trabalhos.mdf; Integrated Security=True";

I want to replace "E: PAP Jobs Jobs Jobs.mdf" with a dynamic way to find the database, so I can then use the program outside my computer.

The first " Jobs " corresponds to where is the "Jobs.sln", the other folder "Jobs" and "Packages". In the following folder is where you have all . Cs, . xaml, etc.

One of the solutions I found was to put the database inside the /Debug, however I believe it is not the appropriate way to do this.

From now on, thank you.

Answer 1

REFERENCE TO THE APP FOLDER. E:\PAP\aplicativo.exe

'|DataDirectory|\' is the folder in which the 'aplicativo.exe' is.

CASE 1: '\aplicativo.exe' and '\Trabalhos.mdf' are in the same folder
THAT IS TO SAY: 'E:\PAP\aplicativo.exe' and 'E:\PAP\Trabalhos.mdf'

AttachDbFilename=|DataDirectory|\Trabalhos.mdf;

CASE 2: '\aplicativo.exe' and '\Trabalhos.mdf' are in different folders
THAT IS TO SAY: 'E:\PAP\aplicativo.exe' and 'E:\PAP\Trabalhos\Trabalhos\Trabalhos.mdf'

AttachDbFilename=|DataDirectory|\Trabalhos\Trabalhos\Trabalhos.mdf;

SUMMING UP: Use this code. this code. that works.

string stringConexao = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Trabalhos\Trabalhos\Trabalhos.mdf; Integrated Security=True";

Answer 2

Hello, the answer is simple.

Make sure that this database is always present in the root directory of the project executable. So, you can use the line of code that I will show below to get the location of the project folder: Application.StartupPath;

I hope I’ve helped!!

Answer 3

I searched and found 2 ways to find the root directory of a WPF application.

You can do it like this:

System.AppDomain.CurrentDomain.BaseDirectory

Or so:

System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName)

I hope this time I’ve helped! :)