public T ExecuteScalar <T>(string connection, string sql, object parameters) { T result = default; using (var c = new MySqlData.MySqlConnection(connection)) { _log.LogTrace <MySqlQuery>($"EXECUTE: {sql}. Parameters: {JsonConvert.SerializeObject(parameters)}"); c.Open(); result = c.ExecuteScalar <T>(sql, parameters); c.Close(); } return(result); }