问题描述
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.