Databases
StackOverflow2013
Postsdbo
POHandle concurrency in Entity Framework
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHandle concurrency in Entity Framework
    primarykey
    data
    text
    <p>I am looking for the best way to handle concurrency while using Entity Framework. The simplest and most recommended (also on stack) solution is described here: <a href="http://msdn.microsoft.com/en-us/library/bb399228.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/bb399228.aspx</a> And it looks like:</p> <pre><code>try { // Try to save changes, which may cause a conflict. int num = context.SaveChanges(); Console.WriteLine("No conflicts. " + num.ToString() + " updates saved."); } catch (OptimisticConcurrencyException) { // Resolve the concurrency conflict by refreshing the // object context before re-saving changes. context.Refresh(RefreshMode.ClientWins, orders); // Save changes. context.SaveChanges(); Console.WriteLine("OptimisticConcurrencyException " + "handled and changes saved"); } </code></pre> <p>But is it enough? What if something changes between Refresh() and the second SaveChanges()? There will be uncaught OptimisticConcurrencyException?</p> <p>EDIT 2:</p> <p>I think this would be the final solution:</p> <pre><code> int savesCounter = 100; Boolean saveSuccess = false; while (!saveSuccess &amp;&amp; savesCounter &gt; 0) { savesCounter--; try { // Try to save changes, which may cause a conflict. int num = context.SaveChanges(); saveSuccess = true; Console.WriteLine("Save success. " + num.ToString() + " updates saved."); } catch (OptimisticConcurrencyException) { // Resolve the concurrency conflict by refreshing the // object context before re-saving changes. Console.WriteLine("OptimisticConcurrencyException, refreshing context."); context.Refresh(RefreshMode.ClientWins, orders); } } </code></pre> <p>I am not sure if Iunderstand how the Refresh() works. Does it refresh whole context? If yes, why does it take additional arguments (entities objects)? Or does it refreshes only objects specified? For example in this situation what should be passed as Refresh() second argument:</p> <pre><code>Order dbOrder = dbContext.Orders.Where(x =&gt; x.ID == orderID); dbOrder.Name = "new name"; //here whole the code written above to save changes </code></pre> <p>should it be dbOrder?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USrideronthestorm
    1. USrideronthestorm
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHandle concurrency in Entity Framework
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHandle concurrency in Entity Framework
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHandle concurrency in Entity Framework
      1. USprashantsunkari
      1. VTFavorite
    1. CO+1 That was the same objection I had against this example when I first read it! Generally it is bad practice to do "risky" operations (saveChanges) in an exception handler. I was amazed to see this in official documentation.
      singulars
      1. POHandle concurrency in Entity Framework
      1. USGert Arnold
    2. CORe: your change, it looks good. I being careful would probably put in a way to break the loop if say 100 retries fail to remedy the situation. Always hard to debug problems that end up in never ending loops. Even though they should never happen ;-)
      singulars
      1. POHandle concurrency in Entity Framework
      1. USJoachim Isaksson
    3. COTry the approach in this link it uses an different way of handling the concurreny , which might be more reliable apprach to follow:- http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/handling-concurrency-with-the-entity-framework-in-an-asp-net-mvc-application
      singulars
      1. POHandle concurrency in Entity Framework
      1. USjohn G
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload