SqlConnection string

Question

I am trying to make a portable connection string with a service-based database.

If I use

C:\Users\X\Desktop\C# Projects\Windows Form Applications\PortableConnectionString\PortableConnectionString\BazaDate.mdf

and not |DataDirectory|BazaDate.mdf, it works.

What can I do to make it portable?

SqlConnection conn= new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\BazaDate.mdf;Integrated Security=True;");
conn.Open();

This isn't a right practice. you are exposing your filename/path. — Khurram Shaikh
– Khurram Shaikh, Commented Oct 20, 2019 at 11:31

joehoper · Accepted Answer · 2019-10-20 12:00:00Z

2

Environment.GetCommandLineArgs()[0] is the full path of your executable, thus:

string appPath = Path.GetDirectoryName(Environment.GetCommandLineArgs()[0]);
string connStr = $@"Data Source=(LocalDB)\v11.0;AttachDbFilename={appPath}\BazaDate.mdf;Integrated Security=True;";

var conn = new SqlConnection(connStr);
conn.Open();

answered Oct 20, 2019 at 12:00

joehoper

4233 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

SqlConnection string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related