it:ad:ef:howto:use_transactions

IT:AD:EF:HowTo:Use Transactions

The following demonstrates opening a specific connection (you don't need to make a connection, and create a new DbContext with it).


var mydb = new MyEFDB();
mydb.Connection.Open();
var tran = mydb.Connection.BeginTransaction();
...
// (now you can mix you EF code with your TSQL code)
...
mydb.ExecuteStoreCommand("DELETE FROM MyTable WHERE ...");
...
foreach(var c in mydb.Customers)
  c.Name=....
...
mydb.SaveChanges();
tran.Commit();
mydb.Connection.Close();

  • /home/skysigal/public_html/data/pages/it/ad/ef/howto/use_transactions.txt
  • Last modified: 2023/11/04 01:42
  • by 127.0.0.1