Repository navigation
Consider using Microsoft.Data.SqlClient instead of System.Data.SqlClient in MsSqlDataConnection #528
Description
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/
Activity
KirillKornienko commentedon Dec 15, 2022
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 commentedon Dec 15, 2022
It is compatible. Plus it supports more connection string formats
rafaelchei commentedon Mar 9, 2023
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
BogdanStg commentedon Mar 31, 2023
Hello!
Microsoft.Data.SqlClient instead of System.Data.SqlClient is planned in the next release, expect changes
Best regards,
Bogdan
MaximBalaganskiy commentedon Apr 2, 2024
Any progress on this?
MaximBalaganskiy commentedon Feb 16, 2025
@BogdanStegachev Please reopen, this is not resolved
BogdanStg commentedon Feb 17, 2025
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
MaximBalaganskiy commentedon Jan 4, 2026
Any progress?
BogdanStg commentedon Jan 5, 2026
Hello!
We will raise the priority on this issue and as soon as the changes are available in FastReport OpenSource we will inform you in this issue
TheronPatrickALN commentedon Aug 15, 2026
Any update on this? System.Data.Sqlclient does not support Managed Identity
BogdanStg commentedon Aug 17, 2026
Thank you for the information you have provided!
Our developers are still working on implementing this feature, but I will pass on all your feedback to them to raise the priority of the attached task.
BogdanStg commentedon Aug 31, 2026
Hello!
Thank you for wait!
Our developers have successfully replaced System.Data.SqlClient with Microsoft.Data.SqlClient. Please look out for these changes in the next version of FastReport Open Source