How to get ConnectionString from appsettings.json in ASP.NET Core
By FoxLearn 2/18/2024 9:31:28 AM 40
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 fix "InvalidOperationException: No service for type 'Microsoft.AspNetCore.Identity.UserManager'"
- How to fix 'IMvcBuilder' does not contain a definition for 'AddNewtonsoftJson'
- ASP.NET Core: How to Create RDLC Report in ASP.NET Core
- How to fix Assets file 'project.assets.json' not found
- How to fix 'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer'
- How to set cookie ValidationInterval in ASP.NET Core
- How to fix LoginPath not working in ASP.NET Core
- How to fix Unable to resolve service for type 'Microsoft.AspNetCore.Identity.UserManager'
Categories
Popular Posts
Visual Studio: Auto increment version
04/01/2024
What is ARM architecture?
04/01/2024