Get Connection String automatically in Visual Studio

Question

I've connected a database file (made from SQL Server .mdf) to one of my C# program. But when I take those files to another PC I need to give the connection string again. It's very annoying for me.

Is there any way to get that connection string automatically when I move my project files to another PC?

Any suggestion would be appreciated.

KARAN · Accepted Answer · 2016-08-22 04:30:13Z

1

Yes it is Possible.

Suppose Your Project name is MYproject.

So Please put your database in the Follwing path D:\Projects\MYproject\MYproject.UI\bin\Debug\Database\sql.mdf.

Change your connection string like below

<connectionStrings>
    <add name="DBNAME" providerName="System.Data.SqlServerCe.4.0" connectionString="Data Source=|DataDirectory|\..\..\..\MYproject.UI\bin\Debug\Database\sql.mdf" />
</connectionStrings>

answered Aug 22, 2016 at 4:30

KARAN

1,0512 gold badges12 silver badges25 bronze badges

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

Comments

Vishal Prajapati · Accepted Answer · 2016-08-22 04:17:30Z

0

No I don't think so this is possible.When you transfer you visual studio solution from one pc to another you have to manually change the connection string either in web.config file or in the c# code.There's no way visual studio can automatically detect the database installed on a particular pc and get the connectionstring from it

answered Aug 22, 2016 at 4:17

Vishal Prajapati

6086 silver badges13 bronze badges

Collectives™ on Stack Overflow

Get Connection String automatically in Visual Studio

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related