ExecuteUpdateAsync of EFCore rely on the source <code

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

closing as <a class="user-mention notranslate" data-hovercard-type="user" data-hoverca

Add predicate to ExecuteUpdateAsync about efcore.genericrepository HOT 3 CLOSED

tanvirarjel commented on May 20, 2024

Add predicate to ExecuteUpdateAsync

from efcore.genericrepository.

Comments (3)

NotAsea commented on May 20, 2024 1

Browsing around source code i find your implementation like this

public async Task<int> ExecuteUpdateAsync<TEntity>(
                    Expression<Func<SetPropertyCalls<TEntity>, SetPropertyCalls<TEntity>>> setPropertyCalls,
                    CancellationToken cancellationToken = default)
                    where TEntity : class
{
     int count = await _dbContext.Set<TEntity>().ExecuteUpdateAsync(setPropertyCalls, cancellationToken);
     return count;
}

So instead of calling ExecuteUpdateAsync directly in DbSet, you can change function a little like so

public async Task<int> ExecuteUpdateAsync<TEntity>(
                    Expression<Func<SetPropertyCalls<TEntity>, SetPropertyCalls<TEntity>>> setPropertyCalls,
                    Expression<Func<TEntity, bool>>? predicate = null
                    CancellationToken cancellationToken = default)
                    where TEntity : class
{
    var dbSet = _dbContext.Set<TEntity>();
    if (predicate != null) dbSet = dbSet.Where(predicate);
    return await dbSet.ExecuteUpdateAsync(setPropertyCalls, cancellationToken);
}