AdoDotNet.Query

This function retrieves the output of a query by utilizing the ADO.NET provider named providerName, with the connection string specified in the parameter connectionString. The connectionString can either be in plain text format or as a collection of property-value pairs. The values for properties can be either text or numerical. It is possible to include an optional parameter called options, which allows for the specification of additional properties. The options parameter can include the following fields: - CommandTimeout: This denotes the duration for which the server-side query is permitted to run before being terminated. The default duration is set at ten minutes. - SqlCompatibleWindowsAuth: This is a Boolean value (true/false) that dictates whether SQL Server-compatible connection string settings for Windows authentication should be generated. The default value is true.