System.Configuration.ConnectionStringSettingsCollection.this[string].get returned null in class

Question

In web.config file i have :

  <connectionStrings> 
    <add name="connectionString" connectionString="Data Source=Server; Initial Catalog=DB; Persist Security Info=true; User ID=****; Password=****" />
  </connectionStrings>

I try to reed this connection string in the class :

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

But I get this error :

System.Configuration.ConnectionStringSettingsCollection.this[string].get returned null

have you ensured that the config file is placed correctly at the directory which you're running the application? in the executing directory does there exist an ApplicationName.exe.config file? — Mohammad
– Mohammad, Commented Dec 8, 2019 at 16:02

Mohammad · Accepted Answer · 2019-12-08 16:12:01Z

3

I suggest in .net core apps use appsettings.json and read connectionString from it :

   static class class
{
    public static IConfigurationRoot Configuration;

    public static string GetConnectionString()
    {
         var builder = new ConfigurationBuilder()
                .SetBasePath(Directory.GetCurrentDirectory())
                .AddJsonFile("appsettings.json");

         Configuration = builder.Build();
         var connectionString = Configuration["ConnectionStrings:connectionString"];

    }
}

appsettings.json :

{
  "ConnectionStrings": {
    "connectionString": "............."
  }
}

answered Dec 8, 2019 at 16:12

Mohammad

1,5771 gold badge17 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

System.Configuration.ConnectionStringSettingsCollection.this[string].get returned null in class

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