How to get the updated record after ExecuteUpdate()?

I'm doing an integration test (real object, no mocks) for a method that executes the below code:

await _domainContext.User
             .Where(x => x.Id == userId)
             .ExecuteUpdateAsync(s =>
                 s.SetProperty(p => p.NumberOfFollowing, p => p.NumberOfFollowing + 1));

I can see on the DB that the value has been increased correctly (before was 0. After the update, it's 1)

After that, I want to assert p.NumberOfFollowing if it has been increased, so I do the below:

 int updatedValue =  _domainContext.User.Single(x => x.Id == userId).NumberOfFollowing;

But the value is always zero (not getting the updated one).

In the test I create the DB context in the Setup and it is shared with all repsitories

It seems that you are using the same instance of the context in both cases. And it seems that you have fetched the user somewhere during the request handling with enabled change tracking, which leads to the stale data. ExecuteUpdateAsync will bypass the change tracking mechanism, so you can try one of the following:

1. Recreate the context: int updatedValue = GetNewContextSomeHow().User.Single(x => x.Id == userId).NumberOfFollowing;

2. Clear change tracker:

_domainContext.ChangeTracker.Clear();
int updatedValue = _domainContext.User.Single(x => x.Id == userId).NumberOfFollowing;

3. Explicitly reloading the data:

var user = _domainContext.User.Single(x => x.Id == userId); _domainContext.Entry(user).Reload();
int updatedValue = user.NumberOfFollowing;

Also maybe just int updatedValue = _domainContext.User.AsNoTracking().Single(x => x.Id == userId).NumberOfFollowing; will work but I can't test it at the moment.