Read Configuration from appsettings.json in Entity Framework

people night dark laptop

After you have done the scaffolding task, the configuration details gets hard-coded on the source code. We have to read connection string from the config file.

Open the DbContext class and comment the warning message in the OnConfiguring method.

Currently, the connection string is hardcoded. It is always a good practice not to keep the configuration details inside the code. We will use the appsettings.json file to keep these details. Create a file with the above name in the project directory.

Add the below content in appsettings.json file.

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "DBConnectionString": "data source=(localdb)\\MSSQLLocalDB;initial catalog=EmployeeDB;Integrated Security=true"
  }
}

Modify the OnConfiguring method in DbContext class to read the connection string from above file.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            var builder = new ConfigurationBuilder()
                              .SetBasePath(Directory.GetCurrentDirectory())
                              .AddJsonFile("appsettings.json");
            var config = builder.Build();
            var connectionString = config.GetConnectionString("DBConnectionString");
 
            if (!optionsBuilder.IsConfigured)
            {
                //#warning To protect potentially sensitive information in your connection string, you should move it out of source code. See http://go.microsoft.com/fwlink/?LinkId=723263 for guidance on storing connection strings.
                optionsBuilder.UseSqlServer(connectionString);
            }
        }

Import the following :

using Microsoft.Extensions.Configuration;
using System.IO;

Thank you All!!! Hope you find this useful.

Published by Jagdish Kumawat

I am a chatbot consultant and developer with a passion for building conversational AI solutions that can help businesses enhance customer engagement, improve efficiency, and increase ROI. I founded Dewiride Technologies, a conversational AI consultancy that specializes in building chatbots and SaaS solutions for businesses. With years of experience in the field, I have honed my skills in building chatbots using popular platforms such as Microsoft Bot Framework, Dialogflow, RASA, Power Virtual Agents, and Amazon LEX. In addition to chatbots, I also specialize in developing custom SaaS solutions that are designed to streamline business operations and enhance productivity. My core expertise lies in building Microsoft Teams apps and bots. I understand the importance of collaboration and communication in today's fast-paced business world, and I work tirelessly to create chatbots and apps that can help teams work more effectively and efficiently. I am committed to staying up-to-date with the latest trends and technologies in the industry. I understand that the world of AI is constantly evolving, and I am always looking for ways to improve my skills and knowledge. Whether you need a simple chatbot for customer service or a more complex AI-powered virtual assistant, I have the expertise to deliver high-quality solutions that can help take your business to the next level. If you have any questions or would like to learn more about how I can help your business, please don't hesitate to get in touch.

CSharp, Programming

Leave a Reply

Up ↑

%d bloggers like this: