在ASP.NET应用程序中安全地存储连接字符串

  <add name="MyConnectionString" connectionString="Data Source=myServerAddress;Initial Catalog=myDBName;User ID=myUsername;Password=myPassword;" />
</connectionStrings>

string connectionString = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

// 使用Azure Key Vault SDK创建KeyVaultClient
var keyVaultClient = new KeyVaultClient(new KeyVaultClient.AuthenticationCallback(async (authority, resource, scope) =>
{
    var clientCredential = new ClientCredential(clientId, clientSecret);
    var context = new AuthenticationContext(authority, null);
    var result = await context.AcquireTokenAsync(resource, clientCredential);
    return result.AccessToken;
}));

// 从Azure Key Vault中获取连接字符串
var secret = await keyVaultClient.GetSecretAsync("https://your-key-vault-name.vault.azure.net/secrets/MyConnectionString/");
var connectionString = secret.Value;

string connectionString = Environment.GetEnvironmentVariable("MyConnectionString");

// 使用Azure App Configuration SDK创建ConfigurationClient
var connectionStringSetting = "MyConnectionString";
var configuration = new ConfigurationClient(new Uri("https://your-app-configuration-store-name.azconfig.io"), new DefaultAzureCredential());

// 从Azure App Configuration中获取连接字符串
var connectionString = configuration.GetConfigurationSetting(connectionStringSetting).Value;