Consider using Microsoft.Data.SqlClient instead of System.Data.SqlClient in MsSqlDataConnection

[MaximBalaganskiy]

Is your feature request related to a problem? Please describe.
Azure Managed Identity connection strings are not supported in System.Data.SqlClient.SqlConnection

Describe the solution you'd like
Return Microsoft.Data.SqlClient.SqlConnection from GetConnectionType

Describe alternatives you've considered
The alternative is to create a custom FR connection

Additional context
See https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/

[KirillKornienko]

Thanks for the idea. Is the new SqlClient fully compatible with the old SqlClient? I think we need to add new plugin with other name for minimize user's errors but I have no idea what the new plugin will be called and maybe we really need to replace it.

[MaximBalaganskiy]

It is compatible. Plus it supports more connection string formats

[rafaelchei]

Like @MaximBalaganskiy said, it is compatible but I just want to point out that Microsoft.Data.SqlClient has a breaking change, the Encryption is now On by Default.
I guess this is just one more reason to add a new plugin instead of using the current one.

See here: https://weblog.west-wind.com/posts/2021/Dec/07/Connection-Failures-with-MicrosoftDataSqlClient-4-and-later#encryption-is-now-on-by-default

[BogdanStegachev]

Hello!

Microsoft.Data.SqlClient instead of System.Data.SqlClient is planned in the next release, expect changes

Best regards,
Bogdan

[MaximBalaganskiy]

Any progress on this?

[MaximBalaganskiy]

@BogdanStegachev Please reopen, this is not resolved

[BogdanStegachev]

Hello!

At the moment the replacement of Microsoft.Data.SqlClient instead of System.Data.SqlClient is not completed, as soon as there are changes we will immediately inform you in this issue

Best regards,
Bogdan