Dot NET 6 API PRoject

saber mohamed

i have 3 connection string with 3 dbcontext

my quetion how to change connetion string manual thorw api endpoind from dev connetion to qas or prod connetion

var pro = builder.Configuration.GetConnectionString(“Prod”); builder.Services.AddDbContextPool(options => options/*.UseLazyLoadingProxies()*/.UseSqlServer(connection));

//------

var qas = builder.Configuration.GetConnectionString("Qas"); builder.Services.AddDbContextPool(options => options/*.UseLazyLoadingProxies()*/.UseSqlServer(connection));

//------ var dev = builder.Configuration.GetConnectionString(“Dev”); builder.Services.AddDbContextPool(options => options/*.UseLazyLoadingProxies()*/.UseSqlServer(connection));

//------

2 Replies

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

Anupam Maiti4y ago
Do you have 3 different set of connection strings for same env? If it is mutiple env , then I would suggest to create 3 different set of appsettings.json file based on enviroment like dev.appsettings.json , qa.appsettings.json etc. then in Program.cs read it like below -
```
public static IConfiguration Configuration { get; } = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", false, true)
.AddJsonFile($"appsettings.{CurrentEnvironment}.json", optional: true)
.AddEnvironmentVariables()
.Build();
```
+1
Sachin Singh4y ago
Switch according to environment variable
var env=Environment.GetEnvironmentVariable("ASPNETCORE_ENVIRONMENT");
if(env=="Pro"){//todo}else if(env=="QA"){//todo} else {//dev}
set the environment variable either through control panel of PC/Server or through code
"profiles": {
    "EnvironmentsSample": {
      "commandName": "Project",
      "dotnetRunMessages": true,
      "launchBrowser": true,
      "applicationUrl": "DEV URL",
      "environmentVariables": {
        "ASPNETCORE_ENVIRONMENT": "DEV"
      }
    },
    "EnvironmentsSample-QA": {
      "commandName": "Project",
      "dotnetRunMessages": true,
      "launchBrowser": true,
      "applicationUrl": "QA URL",
      "environmentVariables": {
        "ASPNETCORE_ENVIRONMENT": "QA",
        "ASPNETCORE_DETAILEDERRORS": "1",
        "ASPNETCORE_SHUTDOWNTIMEOUTSECONDS": "3"
      }
    },
+1