EF Migrarions: How to select the appsettings.env.json for the appropriate database connection string

[fpiazza99]

We have a Dev, Stage, Prod setup and would like to target only the environment being deployed during a EF Migration/Database-Update/"dotnet ef database update". We store each environments connection string in the environment specific appsettings.ENV.json config file. So how do we direct "dotnet ef database update" to use a specific environment?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 263f21d6-6edc-7582-e0e2-fa1c9670bcc0
• Version Independent ID: b3dd8c84-18b1-f98d-64f1-7897d1482692
• Content: EF Core tools reference (.NET CLI) - EF Core
• Content Source: entity-framework/core/miscellaneous/cli/dotnet.md
• Product: entity-framework
• GitHub Login: @bricelam
• Microsoft Alias: bricelam

[eskensberg]

I would also like to know how to update the database with a custom connection string please!

[bricelam]

set ASPNETCORE_ENVIRONMENT=Stage
dotnet ef database update

[bricelam]

See also dotnet/efcore#10750

[christianacca]

Setting the ASPNETCORE_ENVIRONMENT environment variable seems to have no affect for me.

Here's the command I used (in powershell)

$env:ASPNETCORE_ENVIRONMENT='Development'
dotnet ef database update -p FrontEnd.DataAccess -s FrontEnd.Api --no-build

[ajcvickers]

Duplicate of #1050