• 我已经在portal中创建了Azure keyvault和Azure数据库。
• 在keyvault中添加了secret，在创建secret时，我将SQL连接字符串作为值。

下面是我的代码。

using System;
using System.Threading.Tasks;
using Azure.Identity;
using Azure.Security.KeyVault.Secrets;
using System.Data.SqlClient;

namespace Example
{
    class Program
    {
        static async Task Main(string[] args)
        {
            // Initialize Azure credentials
            var credential = new DefaultAzureCredential();

            // Retrieve the SQL database connection string from Azure Key Vault
            var secretClient = new SecretClient(new Uri("https://enter your keyvault name.vault.azure.net/"), credential);
            var connectionString = (await secretClient.GetSecretAsync("secret name")).Value.Value;

            // Connect to the SQL database
            using var connection = new SqlConnection(connectionString);
            await connection.OpenAsync();

            // Create a new SQL user with the desired credentials
            var command = new SqlCommand("CREATE USER Admin21 WITH PASSWORD = 'password'", connection);
            await command.ExecuteNonQueryAsync();

            // Close the database connection
            await connection.CloseAsync();

            Console.WriteLine("SQL user created successfully!");
        }
    }
}

输出：

我能够连接数据库中创建的用户。