[HttpGet]
public async Task<ActionResult<List<Workflow>>> GetAllWorkflows(string databaseName)
{
using var connection = new SqlConnection(_config.GetConnectionString("Default"));
var sql = "SELECT [Key],[Code] " +
$"FROM [{databaseName}].[dbo].[workflowTable] " +
"ORDER BY [Key] ASC;";
var workflows = await connection.QueryAsync<Workflow>(sql);
return Ok(workflows);
}
[HttpGet]
public async Task<ActionResult<List<Workflow>>> GetAllWorkflows(string databaseName)
{
using var connection = new SqlConnection(_config.GetConnectionString("Default"));
var sql = "SELECT [Key],[Code] " +
$"FROM [{databaseName}].[dbo].[workflowTable] " +
"ORDER BY [Key] ASC;";
var workflows = await connection.QueryAsync<Workflow>(sql);
return Ok(workflows);
}