使用微软企业库中数据模块完成事务操作

最新推荐文章于 2019-10-14 18:37:04 发布

原创最新推荐文章于 2019-10-14 18:37:04 发布 · 4.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#微软 #string

微软企业库专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个转账功能的实现方法，通过使用事务确保资金转移过程的一致性和安全性。文章详细展示了如何利用IDbTransaction来协调两个数据库操作：从一个账户扣款并为另一个账户充值。

public bool Transfer(int transactionAmount, int sourceAccount, int destinationAccount)
        {
            bool result = false;

            // Create the Database object, using the default database service. The
            // default database service is determined through configuration.
            Database db = DatabaseFactory.CreateDatabase();

            // Two operations, one to credit an account, and one to debit another
            // account.
            string sqlCommand = "CreditAccount";
            DBCommandWrapper creditCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand);

            creditCommandWrapper.AddInParameter("@AccountID", DbType.Int32, sourceAccount);
            creditCommandWrapper.AddInParameter("@Amount", DbType.Int32, transactionAmount);

            sqlCommand = "DebitAccount";
            DBCommandWrapper debitCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand);

            debitCommandWrapper.AddInParameter("@AccountID", DbType.Int32, destinationAccount);
            debitCommandWrapper.AddInParameter("@Amount", DbType.Int32, transactionAmount);

            using (IDbConnection connection = db.GetConnection())
            {
                connection.Open();
                IDbTransaction transaction = connection.BeginTransaction();

                try
                {
                    // Credit the first account
                    db.ExecuteNonQuery(creditCommandWrapper, transaction);
                    // Debit the second account
                    db.ExecuteNonQuery(debitCommandWrapper, transaction);

                    // Commit the transaction
                    transaction.Commit();

                    result = true;
                }
                catch
                {
                    // Rollback transaction
                    transaction.Rollback();
                }
                connection.Close();

                return result;
            }