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

Question

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)'

Mohammad Komaei · Accepted Answer · 2023-11-26 18:41:23Z

23

we must use : (int?)null

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

edited Nov 26, 2023 at 18:41

answered May 31, 2023 at 14:15

Mohammad Komaei

10.1k2 gold badges41 silver badges47 bronze badges

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

Comments

CPlus · Accepted Answer · 2023-09-11 00:05:30Z

-3

Use this:

SetProperty(UserAccess => UserAccess.ClassId, UserAccess => null)

edited Sep 11, 2023 at 0:05

CPlus

5,11048 gold badges33 silver badges77 bronze badges

answered Sep 9, 2023 at 19:19

Moses Kehengu

344 bronze badges

2 Comments

DaveBagler Over a year ago

Please see @m-komaei's answer. Your answer will result in an ambiguous invocation error.

5andr0 Feb 17 at 19:05

@DaveBagler Not for me. VS understands to call the func prototype here. You can also omit the TSource property: _ => null This comes in handy not having to look up and specify types for multiple columns

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related