How to get ConnectionString from appsettings.json in ASP.NET Core
By Tan Lee Published on Feb 18, 2024 1.11K
This post shows you how to get a connection string from appsettings.json in ASP.NET Core
You can easily find your connection string add in appsettings.json file.
"ConnectionStrings": { "DefaultConnection": "Server=.;Database=dbtest;User Id=sa;Password=123@qaz;Connection Timeout=3000;" }
Creating a AppDbConnection class
public class AppDbConnection { public string DefaultConnectionString { get; set; } }
Opening your Startup class, then add a configuration as shown below.
services.Configure<AppDbConnection>(options => { options.DefaultConnectionString = Configuration.GetConnectionString("DefaultConnection"); });
You can get connection string from your repository as shown below.
private readonly string _connectionString; public DataRepository(IOptions<AppDbConnection> config) { _connectionString = config.Value.DefaultConnectionString; }
- How to Initialize TagHelpers in ASP.NET Core with Shared Data
- Boost Your ASP.NET Core Website Performance with .NET Profiler
- The name 'Session' does not exist in the current context
- Implementing Two-Factor Authentication with Google Authenticator in ASP.NET Core
- How to securely reverse-proxy ASP.NET Core
- How to Retrieve Client IP in ASP.NET Core Behind a Reverse Proxy
- Only one parameter per action may be bound from body in ASP.NET Core
- The request matched multiple endpoints in ASP.NET Core
Categories
Popular Posts
11 Things You Didn't Know About Cloudflare
Dec 19, 2024
Gentella Admin Template
Nov 14, 2024
Focus Admin Dashboard Template
Nov 18, 2024