# ExecuteProcedure

Required Frends version: 5.5+

Required .NET version: 6.0

Compatible Agents: Crossplatform

Source code: <https://github.com/FrendsPlatform/Frends.Salesforce/tree/main/Frends.MySQL.ExecuteProcedure>

{% tabs %}
{% tab title="Parameter: Input" %}

| Name                          | Description                                                                                                                                                                                                                                                                                                           |
| ----------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 🗝ConnectionString : `String` | <p>Mysql connection string</p><p><br>Default: <code>server=server;user=user;database=db;password=pw;</code><br>Example: <code>server=server;user=user;database=db;password=pw;</code></p>                                                                                                                             |
| Query : `String`              | <p>SQL statement to execute at the data source. Usually query or name of a stored procedure. <https://dev.mysql.com/doc/dev/connector-net/8.0/html/P_MySql_Data_MySqlClient_MySqlCommand_CommandText.htm></p><p><br>Default: <code>ProcedureName</code><br>Example: <code>SELECT ColumnName FROM TableName</code></p> |
| Parameters : `Parameter[]`    | <p>Parameters for the database query</p><p><br>Default: <code>-</code><br>Example: <code>Name: ValueName</code></p>                                                                                                                                                                                                   |
| {% endtab %}                  |                                                                                                                                                                                                                                                                                                                       |

{% tab title="Parameter: Options" %}

| Name                                                    | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| ------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| TimeoutSeconds : `Int32`                                | <p>Timeout value in seconds</p><p><br>Default: <code>30</code><br>Example: <code>30</code></p>                                                                                                                                                                                                                                                                                                                                                                                                          |
| TransactionIsolationLevel : `TransactionIsolationLevel` | <p>Transaction isolation level to use.</p><p>Possible values:</p><ul><li><code>ReadCommitted</code>:</li></ul><p>Transaction isolation level to use.</p><ul><li><code>Serializable</code>:</li></ul><p>Transaction isolation level to use.</p><ul><li><code>ReadUncommitted</code>:</li></ul><p>Transaction isolation level to use.</p><ul><li><code>RepeatableRead</code>:</li></ul><p>Transaction isolation level to use.</p><p><br>Default: <code>3</code><br>Example: <code>ReadCommited</code></p> |
| {% endtab %}                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |

{% tab title="Result: Result" %}

| Name                   | Description                                               |
| ---------------------- | --------------------------------------------------------- |
| AffectedRows : `Int32` | <p>Count of affected rows<br>Example: <code>10</code></p> |
| {% endtab %}           |                                                           |
| {% endtabs %}          |                                                           |