maqs-dotnet
maqs-dotnet copied to clipboard
Update System.Data.SqlClient to Microsoft.Data.SqlClient
From https://learn.microsoft.com/en-us/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace?view=sql-server-ver16
The Microsoft.Data.SqlClient namespace is essentially a new version of the System.Data.SqlClient namespace. Microsoft.Data.SqlClient generally maintains the same API and backwards compatibility with System.Data.SqlClient
This would give us access to new and helpful functionalities like setting the Command Timeout directly from the Connection Strings. MAQS does currently support setting the Command Timeout but this needs to be set for every Query method call. This would help us support long running queries from specific databases.
Update in: https://github.com/CognizantOpenSource/maqs-dotnet/blob/main/Framework/BaseDatabaseTest/Providers/SQLServerProvider.cs