Visual C# Creating a database path so that it runs on different PCs

Question

I have created a Visual C# application on Visual Studio 2010 that has a database. The path is @"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\Sch\AAAA\Project\Scholarships\Scholarships\Database1.mdf;Integrated Security=True;User Instance=True"

But every time I want to run the application on a different PC, I have to change the path from E:\Sch\AAAA\Project\Scholarships\Scholarships\Database1.mdf to C:\Folder1\Scholarships\Scholarships\Database1.mdf or something

Is there any way to change the path to a local path or something so that I won't have to change it every time I run the application on a different PC?

Steve · Accepted Answer · 2023-02-18 09:29:34Z

3

Use the DataDirectory substitution string

@"Data Source=.\SQLEXPRESS;" + 
"AttachDbFilename=|DataDirectory|\MyAppDataFolder\Database1.mdf;" +
"Integrated Security=True;User Instance=True"

Where is DataDirectory

|DataDirectory| (enclosed in pipe symbols) is a substitution string that indicates the path to the database. It eliminates the need to hard-code the full path which leads to several problems as the full path to the database could be serialized in different places. DataDirectory also makes it easy to share a project and also to deploy an application.

In this way the location of your database could be easily managed from inside of your application. You can change the actual directory pointed by DataDirectory using this command (before any data access code is executed)

string commonFolder = Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData);
string myAppFolder = Path.Combine(commonFolder, "MyAppDataFolder");
// This willl do nothing if the folder already exists
Directory.CreateDirectory(myAppFolder);
AppDomain.CurrentDomain.SetData("DataDirectory", myAppFolder);

This will resolve (on Win7) to C:\programdata\myappdatafolder\database1.mdf

edited Feb 18, 2023 at 9:29

answered Jul 12, 2013 at 13:50

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Shev Over a year ago

before \Database1.mdf do I add any other path? or just like you posted it?

Steve Over a year ago

Usually the correct folder is a subfolder of the CommonApplicationFolder. Added an example

Shev Over a year ago

I get a lot of errors on the code about commonFolder, like invalid token '('

Steve Over a year ago

Yes sorry, copy, paste, removed the spurious )

Shev Over a year ago

Οn the AppDomain.CurrentDomain i get this error

Error	1	Invalid token '(' in class, struct, or interface member declaration	E:\Σχολή\Τεχνολογία Λογισμικού\Εργασία\Scholarships\Scholarships\Form3.cs	17	40	Scholarships

|

spender · Accepted Answer · 2013-07-12 13:49:20Z

2

Make the path to your db file configurable in appsettings in your app.config.

answered Jul 12, 2013 at 13:49

spender

121k36 gold badges245 silver badges369 bronze badges

Collectives™ on Stack Overflow

Visual C# Creating a database path so that it runs on different PCs

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related