ExecuteQuery

Execute queries against the MySql database and return result of query in JToken.

Task version: 1.4.0

Required Frends version: 5.5+

Required .NET version: 6.0

Compatible Agents: Crossplatform

Source code: https://github.com/FrendsPlatform/Frends.MySQL

Task Parameters

QueryInput

Name	Description
🗝ConnectionString : String	Mysql connection string. Default: - Example: server=server;user=user;database=db;password=pw;
CommandText : String	SQL statement to execute at the data source. Usually query or name of a stored procedure. Default: - Example: SELECT ColumnName FROM TableName
Parameters : Parameter[]	Parameters for the database query. Default: - Example: foo, bar

Options

Name	Description
TimeoutSeconds : Int32	Timeout value in seconds Default: 30 Example: 30
MySqlTransactionIsolationLevel : MySqlTransactionIsolationLevel	Transaction isolation level to use. Possible values: RepeatableRead: Transaction isolation level to use. ReadCommitted: Transaction isolation level to use. ReadUncommitted: Transaction isolation level to use. Serializable: Transaction isolation level to use. Default: - Example: Default
ExecuteType : ExecuteType	Type of query execution. Possible values: Auto: Type of query execution. NonQuery: Type of query execution. Scalar: Type of query execution. Reader: Type of query execution. Default: 1 Example: Auto

Task Result

Name	Description
Success : Boolean	Task status. Example: true
ResultJtoken : Object	Result value(s). Example: [{"name": "foo", "value": 123}]

Task Changelog

Changelog for Task Frends.MySQL.ExecuteQuery.

[1.4.0] - 2025-12-19

Fixed

• Allow defining execute type.
• Fix the issue with respecting timeout.

[1.3.0] - 2025-09-22

Fixed

• Respect Options.TimeoutSeconds in MySql commands

[1.2.0] - 2025-03-18

Updated

• Update packages: Dapper 2.1.28 -> 2.1.66 MySqlConnector 2.3.5 -> 2.4.0 coverlet.collector 3.1.2 -> 6.0.4 Microsoft.NET.Test.Sdk 17.1.0 -> 17.13.0 NUnit 3.13.3 -> 4.3.2 NUnit.Analyzers 3.3.0 -> 4.6.0 NUnit3TestAdapter 4.2.1 -> 5.0.0

[1.1.0] - 2024-03-07

Updated

• Changed MySqlData -library to MySqlConnector -library.

[1.0.1] - 2023-01-02

Fixed

• Fixed issue with Task's result couldn't be referenced with dot notation by changing the ResultJtoken to dynamic.
• Changed the Newtonsoft.Json version to 12.0.1 to be same what Frends is using.

[1.0.0] - 2022-10-12

Added

• Initial implementation