开发者

MVC EF4 SP roolback

my app type is MVC Application. and DB is SQL SERVER 2008. Every operation on DataBase tables are going 开发者_如何转开发with Stored Procedures. in one page i am going to add new rows to two different tables with two different stored procedures. between this tables has relation. in my [Post]Create() Action i call both of this SP. but my problem is: if any of this stored procedures executed with no success then roolback. No any rows must inserted no to first table no to the second table. How i can do this process?

To my ViewModel includes both of this tables...


Consider using TransactionScope

using (var scope = new new TransactionScope())
using (var context = new MyDbContext())
{
    contex.SP1();
    contex.SP2();
    scope.Complete();
}
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜