How can i access connection string form appsetting.json file

Question

I have connection string in appsettings.json file. I need to access that connection string Class library Project. i done the following code to access connection stirng but still i am getting null.   startup.cs public  Startup(IConfiguration configuration)   {   Configuration = configuration;   }   public  IConfiguration Configuration {  get ; }   // This method gets called by the runtime. Use this method to add services to the container.    public   void  ConfigureServices(IServiceCollection services)   {   services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);   services.AddSingleton (Configuration);   }   In class library project protected   string  ConnectionString;   protected   int  CommandTimeout;   private  IConfiguration _config;   #endregion    public  Database(IConfiguration configuration)   {   _config = configuration;   }   #region Constructor    public  Database()   {   ConnectionString = _config.GetConnectionString( "DefaultConnection" );   CommandTimeout = 60;   }   Please give me solution for this ASAP   and i gone through the below link   https://stackoverflow.com/questions/51304432/how-to-read-connection-string-inside-net-standard-class-library-project-from-as   but i could not understand to inject the connection stings

Sivakumar Koneti · Answer

read once can get an idea    https://www.c-sharpcorner.com/blogs/dynamic-connectionstring-in-net-core

Ronika Jency · Answer

Hi,   Please refer below links,   https://www.c-sharpcorner.com/article/setting-and-reading-values-from-app-settings-json-in-net-core/   https://stackoverflow.com/questions/45796776/get-connectionstring-from-appsettings-json-instead-of-being-hardcoded-in-net-co/45845041   https://stackoverflow.com/Questions/45796776/Get-connectionstring-from-Appsettings-JSON-instead-of-Being-Hardcoded-in-Net-Co   https://forums.asp.net/t/2129593.aspx?How+to+dynamically+read+connection+string+from+appsettings+json

Shailesh Uke · Answer

STEP 1: Include the following in OnConfiguring()   protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { IConfigurationRoot configuration = new ConfigurationBuilder() .SetBasePath(AppDomain.CurrentDomain.BaseDirectory) .AddJsonFile("appsettings.json") .Build(); optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection")); }   STEP 2: Create appsettings.json:   { "ConnectionStrings": { "DefaultConnection": "Server=YOURSERVERNAME; Database=YOURDATABASENAME; Trusted_Connection=True; MultipleActiveResultSets=true" } }

Harish Batchu · Answer

I am using ADO.Net

Sivakumar Koneti · Answer

Read below link connection  implementation is available    https://www.c-sharpcorner.com/blogs/database-connections-in-asp-net-core-20

Tamal Marick · Answer

STEP 1: Include the following in OnConfiguring()
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
IConfigurationRoot configuration = new ConfigurationBuilder()
.SetBasePath(AppDomain.CurrentDomain.BaseDirectory)
.AddJsonFile("appsettings.json")
.Build();
optionsBuilder.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
}
STEP 2: Create appsettings.json:
{
"ConnectionStrings": {
"DefaultConnection": "Server=YOURSERVERNAME; Database=YOURDATABASENAME; Trusted_Connection=True; MultipleActiveResultSets=true"
}
}
STEP 3: Hard copy appsettings.json to the correct directory
Hard copy appsettings.json.config to the directory specified in the AppDomain.CurrentDomain.BaseDirectory directory.
Use your debugger to find out which directory that is.
Assumption: you have already included package Microsoft.Extensions.Configuration.Json (get it from Nuget) in your project.