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) { const string sql = "update TransactionCommit 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); } }