How to get ConnectionString from appsettings.json in ASP.NET Core
By FoxLearn 2/18/2024 9:31:28 AM 82
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 Minify HTML using WebMarkupMin in ASP.NET Core
- How to fix 'IMvcBuilder' does not contain a definition for 'AddNewtonsoftJson'
- How to fix System.InvalidOperationException: Scheme already exists: Identity.Application
- The name 'Session' does not exist in the current context
- How to fix 'DbContextOptionsBuilder' does not contain a definition for 'UseSqlServer'
- How to fix Using 'UseMvc' to configure MVC is not supported while using Endpoint Routing
- How to Increase upload file size in ASP.NET Core
- How to fix LoginPath not working in ASP.NET Core
Categories
Popular Posts
C# Tutorial
07/20/2024
How to Download Microsoft SQL Server
06/22/2024
What Are RESTful Web Services?
02/19/2024