Adding database server information in C# application

Question

I am using the following connection string in my c# application to communicate to my database which is hosted locally.

string conn = String.Format("Server={0};Port={1};" +
                                "User Id={2};Password={3};Database={4};",
                                "localhost", "5432", "postgres",
                                "postgres", "table");
NpgsqlConnection connection = new NpgsqlConnection(connstring);
connection.Open();
NpgsqlCommand sqlcmd = new NpgsqlCommand("SELECT * FROM public.roads", connection);
NpgsqlDataReader r = sqlcmd.ExecuteReader();

Is there a way I can add the server information in config.app file and access it in my code?

Possible duplicate of How to use Entity Framework + PostgreSQL from connection? — TAHA SULTAN TEMURI
– TAHA SULTAN TEMURI, Commented Jun 20, 2018 at 5:39
yes add that in app.config or web.config file. And access that by configuration manager — Bhuban Shrestha
– Bhuban Shrestha, Commented Jun 20, 2018 at 5:48
@BhubanShrestha thanks for your comment. Can you provide me with a link or any resource related to this. I am new to c# development. — raosaeedali
– raosaeedali, Commented Jun 20, 2018 at 5:51
connectionstrings.com/store-connection-string-in-webconfig You need to add reference to configuration manager to access connection string in config file — Bhuban Shrestha
– Bhuban Shrestha, Commented Jun 20, 2018 at 5:54

Mark · Accepted Answer · 2018-06-20 07:04:54Z

1

Check out Connection Strings and Configuration Files.

In the app/web.config:

<configuration>
  <configSections>
  (...)
  <connectionStrings>
    <add name="Name1" connectionString="..." />
  </connectionStrings>

In the code:

var connectionString = ConfigurationManager.ConnectionStrings["Name1"].ConnectionString;

Please note that the benefit of using connectionStrings section and not the appSettings is that if you're using an object-relational mapping framework there may be a support for using the connection string by name.

e.g.

public class RepositoryContext: DbContext
{
    public RepositoryContext() : base("Name1") 
    {
        (...)
    }

edited Jun 20, 2018 at 7:04

Mark

2,0433 gold badges22 silver badges43 bronze badges

answered Jun 20, 2018 at 6:30

tmaj

35.9k12 gold badges108 silver badges143 bronze badges

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

1 Comment

raosaeedali Over a year ago

Had to add {using System.Configuration;} in start and it worked like a charm.

Collectives™ on Stack Overflow

Adding database server information in C# application

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related