Data Source option 'persistent' is gone?

Hello,

With the release of RDM v2022.1, we moved away from the System.Data.SqlClient library to using the new Microsoft.Data.SqlClient.

With the old library we had to perform the authentication in our code but with the new library Microsoft takes care of the authentication hence we have less control. On the other hand, this allows for an easier and more secure configuration as the Azure Active Directory App Registration is no longer required.

Please note that we have no choice to move to the new library since the functionality we required while configuring the Azure Active Directory App Registration has been deprecated by Microsoft.

Unfortunately, the downside is the lost of this functionality. Until we can figure something out or Microsoft enables other modes there is nothing we can do.
https://docs.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient.sqlauthenticationmethod?view=sqlclient-dotnet-standard-4.1

Best regards,