How to use Transaction in Entity Framework?

Question

How to use transactions in Entity Framework? I read some links on Stackoverflow : Using Transactions or SaveChanges(false) and AcceptAllChanges()?

BUT; i have 3 table so i have 3 entities:

CREATE TABLE Personel 
(PersonelID integer PRIMARY KEY identity not null, 
Ad varchar(30), 
Soyad varchar(30),
Meslek varchar(100),
DogumTarihi datetime,
DogumYeri nvarchar(100),
PirimToplamı float);

Go

create TABLE Prim
(PrimID integer PRIMARY KEY identity not null,
PersonelID integer Foreign KEY references Personel(PersonelID),
SatisTutari int,
Prim float,
SatisTarihi Datetime);

Go

CREATE TABLE Finans 
(ID integer PRIMARY KEY identity not null, 
Tutar float);

Personel, Prim, Finans my tables. If you look Prim table you can see Prim value float value if I write a textbox not float value my transaction must run.

using (TestEntities testCtx = new TestEntities())
{
    using (TransactionScope scope = new TransactionScope())
    {
       // do something...
       testCtx.Personel.SaveChanges();
       // do something...
       testCtx.Prim.SaveChanges();
       // do something...
       testCtx.Finans.SaveChanges();
       scope.Complete();
       success = true;
    }
}

How can I do that?

they use 3 different context.... you are trying to save each table independently? — Nix
– Nix, Commented Apr 14, 2010 at 14:27

casperOne · Accepted Answer · 2016-10-21 05:03:09Z

12

When you make the call to SaveChanges, the Entity Framework will perform those operations in a single transaction.

When you use the TransactionScope class, you are saying "I want what runs in this block to be encapsulated in a larger transaction", which is indeed what you do.

When you call Complete on the TransactionScope, that is what perform the committing of all of the operations encapsulated in the transaction defined by the TransactionScope.

edited Oct 21, 2016 at 5:03

answered Apr 14, 2010 at 15:20

casperOne

74.7k19 gold badges189 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gregoire · Accepted Answer · 2010-04-14 15:26:07Z

1

SaveChanges operates within a transaction. SaveChanges will roll back that transaction and throw an exception if any of the dirty ObjectStateEntry objects cannot be persisted.

from the documentation

answered Apr 14, 2010 at 15:26

Gregoire

24.9k7 gold badges50 silver badges74 bronze badges

Comments

Danny Varod · Accepted Answer · 2011-04-06 16:35:07Z

0

There is a similar example in the MSDN site.

answered Apr 6, 2011 at 16:35

Danny Varod

18.3k5 gold badges76 silver badges116 bronze badges

Collectives™ on Stack Overflow

How to use Transaction in Entity Framework?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related