I have two tables. I am updating those tables using entity framework. here is my code
public bool UpdateTables()
{
UpdateTable1();
UpdateTable2();
}
If any table update operation fails other should not be committed how do i achieve this in entity framework?
using (TransactionScope transaction = new TransactionScope())
{
bool success = false;
try
{
//your code here
UpdateTable1();
UpdateTable2();
transaction.Complete();
success = true;
}
catch (Exception ex)
{
// Handle errors and deadlocks here and retry if needed.
// Allow an UpdateException to pass through and
// retry, otherwise stop the execution.
if (ex.GetType() != typeof(UpdateException))
{
Console.WriteLine("An error occured. "
+ "The operation cannot be retried."
+ ex.Message);
break;
}
}
if (success)
context.AcceptAllChanges();
else
Console.WriteLine("The operation could not be completed");
// Dispose the object context.
context.Dispose();
}
use transactionscope
public bool UpdateTables()
{
using (System.Transactions.TransactionScope sp = new System.Transactions.TransactionScope())
{
UpdateTable1();
UpdateTable2();
sp.Complete();
}
}
also you need add System.Transactions to your project refference
You don't need to use a TransactionScope: Entity Framework automatically enforces a transaction when you call SaveChanges() on your context.
public bool UpdateTables()
{
using(var context = new MyDBContext())
{
// use context to UpdateTable1();
// use context to UpdateTable2();
context.SaveChanges();
}
}
You can do something like this....
using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.RepeatableRead }))
{
using (YeagerTechEntities DbContext = new YeagerTechEntities())
{
Category category = new Category();
category.CategoryID = cat.CategoryID;
category.Description = cat.Description;
// more entities here with updates/inserts
// the DbContext.SaveChanges method will save all the entities in their corresponding EntityState
DbContext.Entry(category).State = EntityState.Modified;
DbContext.SaveChanges();
ts.Complete();
}
}
