作者热门文章
- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我有两个表(嗯,两个与这个问题相关):
投注(持有投注;列:Id、、MessagesPosted、)
Bets_Messages(保存投注的论坛消息;列:Id、BetId、)
当我在 Bets_Messages 中插入新的 BetMessage 时,我想更新(准确地说是递增)Bets 中的相应字段。
在纯 T-SQL 中,这将是:
INSERT INTO Bets_Messages (BetId, <bla bla>) VALUES (23, "asfasdfasdf");
UPDATE Bets SET MessagesPosted = MessagesPosted + 1 WHERE Id = 23;
public void PostMessage(MyProject.Entities.BetMessage betMessageEntity)
{
DatabaseDataContext ctx = GetFreshContext(); // GetFreshContext is a private method that practically initializes a new DataContext
Bets_Message msg = new Bets_Message(betMessageEntity);
ctx.Bets_Messages.InsertOnSubmit(msg);
Bet bet = (from b in ctx.Bets where b.Id == (long)betMessageEntity.BetId select b).Single();
bet.MessagesPosted++;
ctx.SubmitChanges();
}
exec sp_executesql N'INSERT INTO [dbo].[Bets_Messages]([ParentMessageId], [BetsId], [UserId], [Subject], [DisplayXml], [Time], [ReplyDepth], [Text])
VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7)
SELECT CONVERT(BigInt,SCOPE_IDENTITY()) AS [value]',N'@p0 bigint,@p1 bigint,@p2 uniqueidentifier,@p3 nvarchar(6),@p4 nvarchar(114),@p5 datetime2(7),@p6 tinyint,@p7 nvarchar(8)',@p0=NULL,@p1=1,@p2='A0D253AF-6261-49AE-8C11-BA6117EF35C7',@p3=N'aaawww',@p4=N'<m ai="a0d253af-6261-49ae-8c11-ba6117ef35c7" a="AndreiR" s="aaawww" t="2009-01-31T18:04:31.282+02:00">wwwwwaaa</m>',@p5='2009-01-31 18:04:31.2820000',@p6=0,@p7=N'wwwwwaaa'
exec sp_executesql N'UPDATE [dbo].[Bets]
SET [MessagesPosted] = @p17
WHERE ([Id] = @p0) AND ([UserId] = @p1) AND ([Bets_CategoriesId] = @p2) AND ([Bets_TypesId] = @p3) AND ([TotalSum] = @p4) AND ([TotalBetters] = @p5) AND ([CreateDate] = @p6) AND ([DeadlineDate] = @p7) AND ([ClosedDate] IS NULL) AND ([Bets_StatusesId] = @p8) AND ([LastBetAdded] IS NULL) AND ([Title] = @p9) AND ([ShortDescription] = @p10) AND ([Description] = @p11) AND ([DescriptionPlainText] = @p12) AND ([Version] = @p13) AND ([ReviewedBy] = @p14) AND ([UrlFragment] = @p15) AND ([MessagesPosted] = @p16) AND ([ClosedBy] IS NULL) AND ([OutcomeNumber] IS NULL)',N'@p0 bigint,@p1 uniqueidentifier,@p2 smallint,@p3 tinyint,@p4 money,@p5 int,@p6 datetime2(7),@p7 datetime2(7),@p8 tinyint,@p9 nvarchar(7),@p10 nvarchar(30),@p11 nvarchar(33),@p12 nvarchar(22),@p13 smallint,@p14 uniqueidentifier,@p15 varchar(7),@p16 int,@p17 int',@p0=1,@p1='A0D253AF-6261-49AE-8C11-BA6117EF35C7',@p2=2,@p3=1,@p4=$0.0000,@p5=0,@p6='2008-12-03 00:00:00',@p7='2008-12-31 00:00:00',@p8=2,@p9=N'Pariu 1',@p10=N'Descriere pariu 1 - text chior',@p11=N'Descriere pe larg 1 - html permis',@p12=N'descriere text chior 1',@p13=1,@p14='A0D253AF-6261-49AE-8C11-BA6117EF35C7',@p15='pariu-1',@p16=18,@p17=19
最佳答案
编辑 : 实际上重读您的帖子后,我认为 SubmitChanges 生成的自动事务已经负责确保所有语句都完成或没有完成。我在想,由于您使用的是自动生成的 id,您应该在 LINQ 中进行两阶段更新,但似乎 SubmitChanges 会为您处理它。
我将保留下面的代码以供引用,尽管我认为这不是必需的。底部的链接解释了完成交易的不同方式。
您需要的是一个事务范围来包装整个插入/更新集。
using System.Transactions;
public void PostMessage(MyProject.Entities.BetMessage betMessageEntity)
{
using (TransactionScope scope = new TransactionScope()) {
DatabaseDataContext ctx = GetFreshContext();
Bets_Message msg = new Bets_Message(betMessageEntity);
ctx.Bets_Messages.InsertOnSubmit(msg);
ctx.SubmitChanges(); // this is what I thought you did
Bet bet = (from b in ctx.Bets
where b.Id == (long)betMessageEntity.BetId select b)
.Single();
bet.MessagesPosted++;
ctx.SubmitChanges();
scope.Complete();
}
}
关于.net - LINQ to SQL - 更新以增加非主键字段 - 线程安全,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/499130/
我是一名优秀的程序员,十分优秀!