C# SQL Server database connection without native application

Question

I am looking for a suggestion, how can I connect database without writing the connection string in the native application.

I am using this but looking for another so that, when I rename database, the software will connect automatically.

static string conStr = @"server=myServerName;Integrated Security=true;Connection Timeout=5;Database=myDatabaseName;";

Craig W. · Accepted Answer · 2015-05-03 13:41:48Z

1

You can put the connection string in the configuration file.

<connectionStrings>
    <add name="MyDatabase" connectionString="server=myServerName;Integrated Security=true;Connection Timeout=5;Database=myDatabaseName;" providerName="System.Data.SqlClient" />
</connectionStrings>

Then to retrieve the string you want you use:

ConfigurationManager.ConnectionStrings["MyDatabase"].ConnectionString

Asking for it to connect automatically even if you rename the database isn't possible. Think about it, a single server can host hundreds of databases. How would it know which one to connect to?

answered May 3, 2015 at 13:41

Craig W.

18.2k6 gold badges52 silver badges83 bronze badges

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

1 Comment

Dan Guzman Over a year ago

A project reference to the System.Configuration assembly is needed to use this method.

Collectives™ on Stack Overflow

C# SQL Server database connection without native application

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related