Open Closed

Setting the Database Connection String from a KeyVault setting when the environment is Production #981


User avatar
0
jtallon created
  • **ABP Framework version: latest
  • UI type: MVC
  • DB provider: EF Core
  • Tiered (MVC) or Identity Server Separated (Angular): yes

Hi,

Can you please point me in the correct direction to how to configure the database connection string to load from a Key Vault scret (Azure). The part that is causing me the most confusion is how to set the connection string from the Config that is loading from key vault.

I have Configured the Program.cs in the Web project to load settings from kv.

And I have tested to make sure it grabs the values from kv, which seem to be fine.

Lets assume I have a secret called db-string and i want to set the DbConext connection string to that value. How do to get the DbContext to use this connection string?

Regards John


4 Answer(s)
  • User Avatar
    0
    Moyaoxiang created

    Hi @jtallon, You can refer to https://docs.microsoft.com/en-us/aspnet/core/security/key-vault-configuration?view=aspnetcore-5.0#bind-an-array-to-a-class, I think only need to define ConnectionStrings--db-string.

  • User Avatar
    0
    jtallon created

    Thanks for your help @Moyaoxiang, that clears a lot up.

    How can I configure the DbContext to use a specific database connection string config name. By default it used "Default", but I want to tell it to use "Somethingelse" at run time. Not sure of this is an abp config or ef config.

  • User Avatar
    0
    Moyaoxiang created

    Hi jtallon, You can use the ConnectionStringName Attribute. e.g.

    [ConnectionStringName("Default")]
    public class CommercialDemoDbContext : AbpDbContext<CommercialDemoDbContext>
    {
    
    }
    
  • User Avatar
    0
    ServiceBot created
    Support Team Automatic process manager

    This question has been automatically marked as stale because it has not had recent activity.

Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
Do you need assistance from an ABP expert?
Schedule a Meeting
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v9.2.0-preview. Updated on March 13, 2025, 04:08