/// <summary>
/// Task for performing queries IFS Access Provider: http://ifsscan-odemo-2.cloudapp.net/ifsdoc/f1doc/foundation1/050_development/default.htm
/// See documentation at https://github.com/CommunityHiQ/Frends.Community.IFSAccessProvider
/// </summary>
/// <param name="queryInput"></param>
/// <param name="output"></param>
/// <param name="connection"></param>
/// <param name="cancellationToken"></param>
/// <returns>Object { bool Success, string Result, string Message }</returns>
public static async Task <Output> Query([PropertyTab] QueryProperties queryInput, [PropertyTab] OutputProperties output, [PropertyTab] ConnectionProperties connection, CancellationToken cancellationToken)
{
var conn = new FndConnection(connection.Address, connection.Username, connection.Password)
{
AsynchronousMode = connection.AsynchronousMode,
ConnectionTimeout = connection.TimeoutSeconds,
CatchExceptions = false
};
var command = new FndPLSQLSelectCommand(conn, queryInput.Query);
foreach (var param in queryInput.Parameters)
{
command.BindVariables.Add(Extensions.CreateFndParameter(param));
}
var queryResult = await command.ToJsonAsync(output, cancellationToken);
return(new Output {
Result = queryResult, Success = true, Message = null
});
}
