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);
}
}