How will entity framework detect concurrency conflicts , without using timestmp or rowversion

Question

I am working on an asp.net mvc web application that uses entity framework . I have the following model class inside my asp.net mvc web application:-

public partial class TMSSwitchPort
{
    public int TechnologyID { get; set; }
    public int SwitchID { get; set; }
    public string PortNumber { get; set; }

    public virtual Technology Technology { get; set; }
    public virtual TMSSwitch TMSSwitch { get; set; }
}

And I have the following repository method:-

public void changeDeviceSwitch(int fromID , int toID)
{

    var currentdevices = tms.TMSSwitchPorts.Where(a => a.SwitchID == fromID);
    foreach (var d in currentdevices)
    {
        tms.TMSSwitchPorts.Remove(d);            
    }
    foreach (var d in currentdevices)
    {
        TMSSwitchPort tsp = new TMSSwitchPort() { SwitchID = toID,
            TechnologyID = d.TechnologyID, PortNumber = d.PortNumber };
        tms.TMSSwitchPorts.Add(d);
    }
    tms.SaveChanges();
}

The above method will mainly retrieve all objects that have specific switchID , delete them, and add new records with new switchID. Currently I am trying to understand what will happen when concurrent users execute the method at the same time. From my test I find that the first user will be able to delete and add new records, while the other users will get DbUpdateConcurrencyException. So from my understanding I observe the following scenario, let say UserA & UserB access the same method at the same time:-

UserA retrieve all the currentdevices.
UserB retrieve all the currentdevices at the same time.
UserA mark all objects for deletion, create new objects, Save().
UserB mark all objects for deletion, create new objects,
Now when userB reaches the Save() , EF will find that there are some objects (or all of them) that have been marked for deletion but no longer exists (because they were deleted by UserA), and it will raise the DbUpdateConcurrencyException.

So this mean that EF will raise DbUpdateConcurrencyException, when it tries to delete an object/s that no longer exists , even if I am not using a timestamp . I check the sql profiler and the generated sql statement for the delete operation looks as follow:-

exec sp_executesql N'delete [dbo].[TMSSwitchPorts]
where (([SwitchID] = @0) and ([PortNumber] = @1))',N'@0 int,@1 nvarchar(10)',@0=467,@1=N'a'

So is my understanding to the way EF will react to the above code is correct ?

Haney · Accepted Answer · 2014-05-28 00:34:02Z

1

If you read the MSDN article for DbUpdateConcurrencyException you can see these notes that explain it:

Exception thrown by DbContext when it was expected that SaveChanges for an entity would result in a database update but in fact no rows in the database were affected. This usually indicates that the database has been concurrently updated such that a concurrency token that was expected to match did not actually match. Note that state entries referenced by this exception are not serialized due to security and accesses to the state entries after serialization will return null.

answered May 28, 2014 at 0:34

Haney

35.2k9 gold badges61 silver badges71 bronze badges

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

4 Comments

John John Over a year ago

so in this case my assumption is true ? But your link is referring to updating an object ("for an entity would result in a database update but in fact no rows in the database were affected....") ,, while in my case i am deleting objects

Haney Over a year ago

A database update is not an UPDATE statement. It just means a change. Your delete changes it.

John John Over a year ago

thanks for the reply ,,, so my assumption about the way EF will behave to my method is correct , right ?

Haney Over a year ago

According to the documentation, yes! :)

Collectives™ on Stack Overflow

How will entity framework detect concurrency conflicts , without using timestmp or rowversion

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related