Search code examples
c#ef-core-7.0

How to set null in update with ef core 7 ExecuteUpdateAsync SetProperty


I have this method:

public async Task<int> RemoveClassify(RemoveClassifyVm vm)
{
    return await _db.UserAccesses
        .Where(UserAccess => vm.userAccessIds.Any(userAccessId => userAccessId == UserAccess.Id))
        .ExecuteUpdateAsync(UserAccess => UserAccess
         .SetProperty(UserAccess => UserAccess.ClassId, null)
        );
}

but get error : Error CS0121 The call is ambiguous between the following methods or properties: 'SetPropertyCalls.SetProperty(Func<TSource, TProperty>, Func<TSource, TProperty>)' and 'SetPropertyCalls.SetProperty(Func<TSource, TProperty>, TProperty)'


Solution

  • we must use : (int?)null

    SetProperty(userAccess => userAccess.ClassId, (int?)null)