Access Connection String In Asp.Net Core 6 ClassLibrary From appsettings.json C# | appsettings.json Connection String Value Access in Asp.net Core ClassLibrary

 In this article I will show you how you can access connection string from appsetting.json in a class library class file using c#.net in your asp.net core 6 web application or asp.net core mvc application.  So for this first we will add the connection string in your appsetting.json file.

"ConnectionStrings": {     "grattxpertconnection": "Server=.\\SQLEXPRESS;Database=TestDB;Trusted_Connection=True;”   }

 Related Articles:

• Asp.Net Core 6: Connect To Sql Server Database With Entity Framework Using C#
• Access Connection String In Asp.Net Core 6 Controller From appsettings.json C# 
• appsettings.json Connection String Value Access in Asp.net Core Controller

After this we will add a class library project. In this class library we will add a new class file. We will make the added class file as static. Now add a function on which we will access the connection string in our class library.

But before writing the core we need to add the library reference of  Microsoft.Extensions.Configuration.Json and Microsoft.Extensions.Configuration.Binder. For this we will right click on project and click on manager nuget package.  Add search for  Microsoft.Extensions.Configuration.Json and Microsoft.Extensions.Configuration.Binder and install it.

Microsoft.Extensions.Configuration.Json

Microsoft.Extensions.Configuration.Binder

After this we will go to our class file and add the below code.

using Microsoft.Extensions.Configuration; using System; using System.IO;  namespace ClassLibrary1 {     public class Class1     {         public static string Connectionstring()         {             var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json", optional: false);             IConfiguration config = builder.Build();             return config.GetValue<string>("ConnectionStrings:value");         }     } }

 

In above code I have accessed the appsetting.json file and the read the data for specific configuration from appsetting.json file on asp.net core we application. Now we will add the library reference in the project where we want to access the appsetting.json defined connection string.

Now lets access this in our project.