How to add connection string in asp.net core

C# Corner

Peter Cruise

3y1k.NET Core

How to add connection string in asp.net core

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajesh Gami3y ago
Accepted answer
1) https://www.c-sharpcorner.com/blogs/database-connections-in-asp-net-core-20

2) https://stackoverflow.com/questions/39083372/how-to-read-connection-string-in-net-core
+3

Vishal Joshi3y ago

Hello Peter,

You can store the connection string in appsettings.json file.

{
  "ConnectionStrings": {
    "BloggingDatabase": "Server=(localdb)\\mssqllocaldb;Database=EFGetStarted.ConsoleApp.NewDb;Trusted_Connection=True;"
  },
}

You can get the connection string from JSON file using GetConnectionString() and setup in a startup.cs file as shown in the below code.

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext(options =>
        options.UseSqlServer(Configuration.GetConnectionString("BloggingDatabase")));
}

Thanks