Connection string with access token that expires every 24h

[lupustom-ecarup]

Hello everyone,
Is there a way to pass an access credential instead of a fixed connection string? We are using using an Azure hosted PostgreSQL server and connect to it everywhere using managed identity where the access token expires every 24h.
Thanks!

[phillip-haydon]

Just came here looking to see if anyone else run into this, using AWS with IAM Role which generates 15 minute tokens. For EF I can use

dataSourceBuilder.UsePeriodicPasswordProvider(
    (settings, cancellationToken) =>  /* async code to fetch the new access token */,
    TimeSpan.FromMinutes(55), // Interval for refreshing the token
    TimeSpan.FromSeconds(5)); // Interval for retrying after a refresh failure

https://www.npgsql.org/doc/security.html?tabs=tabid-1#auth-token-rotation-and-dynamic-password