public async Task <bool> Update(string unitName, long transactionId, TransactionStatus status) { var sql = $"update {options.Value.TableName} set Status=@Status where UnitName=@UnitName and TransactionId=@TransactionId"; using var conn = CreateConnection(); return(await conn.ExecuteAsync(sql, new { UnitName = unitName, TransactionId = transactionId, Status = status }) > 0); }
public async Task <bool> Update(string unitName, long transactionId, TransactionStatus status) { using var conn = CreateConnection(); return(await conn.ExecuteAsync(update_sql, new { UnitName = unitName, TransactionId = transactionId, Status = status }) > 0); }