ASP.net C# VB.Net PHP
Swoole ASP/ADO/VBScript SQL语言 Python Python3 Diango C语言 Lua C++ Go语言 Revel Docker Ruby Perl Erlang R语言 Julia Apex OAuth 2.0 Arduino 编程经验 汇编语言 树莓派 游戏设计 MATLAB Elasticsearch Numpy F# Delphi HTCondor Rust 易语言 NSQ
用户登录
用户注册

分享至

如何在实体框架中回滚事务

  • 作者: kzh小柯
  • 来源: 51数据库
  • 2022-10-20

问题描述

string[] usersToAdd = new string[] { "asd", "asdert", "gasdff6" };
using (Entities context = new Entities())
{
    foreach (string user in usersToAdd)
    {
        context.AddToUsers(new User { Name = user });
    }
    try
    {
        context.SaveChanges(); //Exception thrown: user 'gasdff6' already exist.
    }
    catch (Exception e)
    {
        //Roll back all changes including the two previous users.
    }

或者这可能是自动完成的，这意味着如果发生错误，则会取消所有更改的提交更改.是吗?

Or maybe this is done automatically, meaning that if error occurs, committing changes are canceled for all the changes. is it?

推荐答案

OK

我创建了一个示例应用程序，就像我在数据库中检查的问题和后记中的示例一样，没有添加任何用户.

I created a sample a application like the example from the the question and afterwords I checked in the DB and no users were added.

结论:ObjectContext.SaveChange 它自动是一个事务.

注意:如果执行 sprocs 等，我相信交易是需要的.

Note: I believe transactions will be needed if executing sprocs etc.

推荐阅读
热点文章

Copyright 2018 51数据库(www.51sjk.com)

软件
前端设计
程序设计
Java相关