Using Azure.Identity to Connect to Azure SQL

Connect.cs

// No credentials needed in the connection string!
var connString = "Server=myserver.database.windows.net;Database=MyDatabase";

var cred = new DefaultAzureCredential();

// Get access token. The scope for Azure SQL is https://database.windows.net.
var token = cred.GetToken(new TokenRequestContext(
    new string[] { "https://database.windows.net" }));

using(var connection = new SqlConnection(connString))
{
    // Set the token
    conn.AccessToken = token.Token;
    conn.Open();

    // Execute your SQL commands
    var count = conn.ExecuteScalar<int>("SELECT COUNT(*) FROM Tenants");
    Console.WriteLine($"There are {count} tenants");
}