예제 #1
0
        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);
        }
예제 #2
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);
            }
        }