Replaced "System.Data.SqlClient" with "Microsoft.Data.SqlClient"

[primez]

Update usage of "System.Data.SqlClient" to "Microsoft.Data.SqlClient"

Description

This pull request updates the usage of "System.Data.SqlClient" to "Microsoft.Data.SqlClient" throughout the codebase. The switch to "Microsoft.Data.SqlClient" aligns with the latest best practices and recommendations from Microsoft. Check more information here - https://devblogs.microsoft.com/dotnet/introducing-the-new-microsoftdatasqlclient/

Changes Made

• Replaced all occurrences of "System.Data.SqlClient" with "Microsoft.Data.SqlClient" in the codebase.
• Updated relevant import statements and namespaces.

Motivation

"Microsoft.Data.SqlClient" is the recommended ADO.NET provider for SQL Server from Microsoft, offering improved performance, security, and compatibility with modern .NET frameworks and tooling. By migrating to "Microsoft.Data.SqlClient", we ensure compatibility with future updates and leverage the latest features and optimizations provided by Microsoft.

Testing

• Tested the updated code locally to ensure it compiles without errors.
• Conducted manual testing to verify the functionality remains intact after the replacement.
• Used the updated compiled DLLs in a proprietary project instead of nuget packages and it worked

[primez]

Hello @paillave. In case you haven't received a notification about the creation of this PR, I would like to bring your attention to it. Thank you.

[paillave]

Hello @paillave. In case you haven't received a notification about the creation of this PR, I would like to bring your attention to it. Thank you.

Hello, sorry for the delay. These last weeks have been hectic. I just approved. Thanks for the commit. I still need to make some tests on other bug fixes and I'll make a release