Support for 'Active Directory Interactive' authentication

problem

Try to connect to an Azure SQL database using the Active Directory Interactive authentication scheme.

open FSharp.Data

[<Literal>]
let connectionString = @"Data Source=asdf.database.usgovcloudapi.net;Initial Catalog=asdf;User ID=abc@def.com;Authentication='Active Directory Interactive';TrustServerCertificate=True;Connect Timeout=30"

do
    use cmd = new SqlCommandProvider<"select * from records", connectionString>(connectionString)

    cmd.Execute(topN = 3L) 

This provides the following error message:

Severity	Code	Description	Project	File	Line	Suppression State
Error	FS3033	The type provider 'FSharp.Data.SqlCommandProvider' reported an error: Cannot find an authentication provider for 'ActiveDirectoryInteractive'.	CopyDataDbToDb	C:\projects2\CopyDataDbToDb\CopyDataDbToDb\Program.fs	7	Active

solution

Ideally, that the authentication scheme is supported

more info

For now, I have copied the DB onto my local machine so I can work with it, but the data will quickly become stale.

What you can do

• I consider contributing the feature
• I consider help in testing the feature

Start with SqlCommandProvider and trace how the connection string's Authentication value is resolved, focusing on the missing ActiveDirectoryInteractive provider. Reproduce the Azure SQL connection failure, then add coverage for the authentication scheme and verify that the sample connection succeeds.