How to bulk update/delete with EF Core 5
Posted: 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.
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.