maqs-dotnet icon indicating copy to clipboard operation
maqs-dotnet copied to clipboard

Update System.Data.SqlClient to Microsoft.Data.SqlClient

Open Skidush opened this issue 3 years ago • 0 comments

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

Skidush avatar Oct 14 '22 10:10 Skidush