Support for Azure SQL Elastic Pools

[thomasvdb]

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [x] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [x] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Should this also work for Azure SQL Elastic Pools?
When executing the following code it throws an Exception that a password hasn't been provided in the connectionstring.

var connBuilder = new SqlConnectionStringBuilder("Server=tcp:xxx.database.windows.net;Initial Catalog=xxx;UID=AnyString;Authentication=Active Directory Interactive");
connBuilder.DataSource = "...";
connBuilder.InitialCatalog = "...";

// Deploy shard map manager.
ShardMapManager smm;
if (ShardMapManagerFactory.TryGetSqlShardMapManager(connBuilder.ConnectionString, ShardMapManagerLoadPolicy.Lazy, out smm))
{
    this.ShardMapManager = smm;
}

It this a supported use-case?

Any log messages given by the failure

'The required property 'Password' must be set in the connection string.

OS and Version?

Windows 10

Versions

.NET Framework version 4.7.2