Comment on page
AdoDotNet.Query
Returns the result of running a native query on an ADO.NET data source.
function (providerName
as text, optionalconnectionString
as nullable any,query
as text, optionaloptions
as nullable record) as table
Returns the result of running
query
with the connection string connectionString
using the ADO.NET provider providerName
. connectionString
can be text or a record of property value pairs. Property values can either be text or number. An optional record parameter, options
, may be provided to specify additional properties. The record can contain the following fields: CommandTimeout
: A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is ten minutes.SqlCompatibleWindowsAuth
: A logical (true/false) that determines whether to produce SQL Server-compatible connection string options for Windows authentication. The default value is true.Accessing data
Last modified 5yr ago