How to bulk update/delete with EF Core 5

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
ivoryguard
Posts: 8
Joined: Wed 13 Oct 2010 01:11

How to bulk update/delete with EF Core 5

Post by ivoryguard » Fri 08 Oct 2021 05:48

Hello.
I am using DotConnect for Oracle/MySQL/SQLite for EF Core 5.

I want to delete mutiple rows with where conditions.
However, default EF Core 5 does not support the feature - it selects rows and deletes each row one by one when I monitor DB.

I found that some EF Core extensions for bulk deleting;
https://github.com/yangzhongke/Zack.EFCore.Batch
https://entityframework-extensions.net/

However, I have no idea where they are compatible to devart EF Core providers.

I can do it by executing Raw SQL scripts, but I want to do it with LINQ elegantly.

Please, let me know how I can achieve my requirement.

Best regards.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: How to bulk update/delete with EF Core 5

Post by Shalex » Tue 12 Oct 2021 14:59

ivoryguard wrote: Fri 08 Oct 2021 05:48 I found that some EF Core extensions for bulk deleting;
https://github.com/yangzhongke/Zack.EFCore.Batch
https://entityframework-extensions.net/

However, I have no idea where they are compatible to devart EF Core providers.
These libraries are not compatible with dotConnect providers. We will investigate the possibility to support them and notify you.

Post Reply