How do I delete multiple records in database using EF Core?

Question

I want to delete according to the AdvertId in it, not according to the ID. I find AdvertId but I'm stuck on deletion. I am using CQRS structure. My Repository and IRepository folders are located separately. In the controller part, I am doing the transaction by finding the advertId.

public class Advert_CategoryPropertyDetailJunctionDeleteHandler : 
        IRequestHandler<Advert_CategoryPropertyDetailJunctionDelete, ApiResponse>
{
    private readonly IUnitOfWork _repo;

    public Advert_CategoryPropertyDetailJunctionDeleteHandler(IUnitOfWork repo)
    {
        _repo = repo;
    }

    public async Task<ApiResponse> Handle(Advert_CategoryPropertyDetailJunctionDelete 
    request, CancellationToken cancellationToken)
    {
        var mapped = await 
        _repo.AdvertCategoryPropertyDetailJunctions.GetAllAsync(request.predicate);

        if (mapped == null)
            return new ErrorApiResponse(ResultMessage.NotDeletedUser);

        await _repo.AdvertCategoryPropertyDetailJunctions.DeleteAllAsync((Advert_CategoryPropertyDetailJunction) mapped);

        return new SuccessApiResponse();
    }
}

IRrepository:

Task<IEnumerable> DeleteAllAsync(T entity);

Repository;

public async Task<IEnumerable> DeleteAllAsync(T entity)
{
    Context.Set<T>().Remove(entity);
    Context.Entry(entity).State = EntityState.Deleted;
    await Context.SaveChangesAsync();
    return (IEnumerable)entity;
}

Does this answer your question? How do I delete multiple rows in Entity Framework Core? — Michael Freidgeim
– Michael Freidgeim, Commented May 29, 2022 at 8:06

Marco Medrano · Accepted Answer · 2022-11-01 17:30:16Z

9

This feature is introduced in EF7 described here.

It would look like:

await context.Customers
    .Where(x => x.AdvertId == advertIdToDelete)
    .ExecuteDeleteAsync();

answered Nov 1, 2022 at 17:30

Marco Medrano

3,1701 gold badge27 silver badges40 bronze badges

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

1 Comment

Michelh91 Over a year ago

Is any additional package needed for this? I'm in .NET 7 and EF Core 7 and ExecuteDeleteAsync or ExecuteUpdateAsync are not available to me. Edit: forget it, working after adding Microsoft.EntityFrameworkCore.Relational package Thanks!

Maxian Nicu · Accepted Answer · 2021-11-05 11:09:20Z

Unfortunately EF Core doesn't support these operations. You have to fetch them all and then delete.

var entities = _repository.GetAllByAdvertId(advertId);
_repository.Delete(entities);

and repository implementation

public async Task<IEnumerable> DeleteAllAsync(IEnumerable<T> entities)
    {
        foreach(var entity of entities){
            Context.Set<T>().Remove(entity);
        }
        await Context.SaveChangesAsync();
        return (IEnumerable)entity;

    }

but this solution is not optimal for large data sets.

If you have a large data set, you can use Z.EntityFramework.Extensions.EFCore package.

context.Customers
    .Where(x => x.AdvertId == AdvertId)
    .DeleteFromQuery();

In this way, the query will be executed in the database and you won't need to fetch all data in the local context to perform this operation.

See examples Batch Operations Methods

Collectives™ on Stack Overflow

How do I delete multiple records in database using EF Core?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related