Linq使用事务

public void AddBook(int userId, acb_Book newBook, bool defaultBook, int startMoney)
{
    using (AccountBookDataContext ctx = new AccountBookDataContext())
    {
        int haveBookCount = ctx.acb_Book.Count(b => b.CreateAccountId == userId);
        if (haveBookCount < 5)
        {
            ctx.Connection.Open();
            ctx.Transaction = ctx.Connection.BeginTransaction(IsolationLevel.Serializable);
            try
            {
                ctx.acb_Book.InsertOnSubmit(newBook);
                ctx.SubmitChanges();

                if (defaultBook)
                {
                    newBook.acb_UserInfo.DefaultBookId = newBook.Id;
                }
                ctx.SubmitChanges();

                if (startMoney != 0)
                {
                    acb_BookItem item = new acb_BookItem();
                    item.AccountDateTime = DateTime.Now;
                    item.CreateAccountId = userId;
                    item.CreaetDateTime = DateTime.Now;
                    item.Name = "我的启动资金";
                    item.Money = startMoney;
                    item.acb_SystemClass = (from sc in ctx.acb_SystemClass where sc.Name == "暂无分类" select sc).Single();
                    newBook.acb_BookItem.Add(item);
                }
                ctx.SubmitChanges();

                ctx.Transaction.Commit();
            }
            catch (Exception ex)
            {
                ctx.Transaction.Rollback();
                throw ex;
            }
            finally
            {
                ctx.Connection.Close();
                ctx.Transaction = null;
            }
        }
        else
        {
            throw new Exception("每个用户只能创建5个帐本");
        }
    }
}

转载于:https://www.cnblogs.com/chiyung/articles/1265971.html