CODEWITHSUNDEEP
asp.net.net-core.net-core-3.0
Lina Milyutina
Lina Milyutina

Reputation: 23

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

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

Upvotes: 2

Views: 1404

Answers (1)

Mohammad
Mohammad

Reputation: 1577

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": "............."
  }
}

Upvotes: 3

Related Questions