.RemoveRange Without fetching database records first in Entity Framework

Question

I am deleting the multiple records from the database using the .RemoveRange, but for that I have to fetch all the records first and then I pass them to the .RemoveRange, but I want to achieve that without fetching the records from the databas? any idea how to achieve that?

db.People.RemoveRange(just giving the ids or list of ids of people class);

Try to create entities with new, assign the ID, then pass it to the function. — ViRuSTriNiTy, Aug 29 '17 at 10:24
Yes doing it like that List ra1 = new List(); ra1.Add(new ResidentAppointment { Id = appointmentId }); _context.ResidentAppointments.RemoveRange(ra1); but getting error like that the object cannot be deleted because it was not found in the objectstatemanager. entity framework — Ali Nafees, Aug 29 '17 at 10:26
I have other ways of doing it, but I want it from .RemoveRange because it is very fast and is done perfectly. — Ali Nafees, Aug 29 '17 at 10:28
You have to attach the entity first, have a look: https://stackoverflow.com/a/19422173/3936440 — ViRuSTriNiTy, Aug 29 '17 at 10:32
I have list of entities, can you please tell me how can I attach the list of entities at once? — Ali Nafees, Aug 29 '17 at 10:33
I would say: `db.People.Attach({your_entity_created_with_new})` — ViRuSTriNiTy, Aug 29 '17 at 10:35
@ ViRuSTriNiTy .I have done that by attaching the entities first. thanks it is working... — Ali Nafees, Aug 29 '17 at 10:45
I posted an answer so you can mark your question as answered. — ViRuSTriNiTy, Aug 29 '17 at 11:07

score 4 · Answer 1 · answered Aug 29 '17 at 10:30

4

Try to use EntityFramework.Extended library, with it you can write:

db.People.Where(x => ids.Contains(x.Id)).Delete();

answered Aug 29 '17 at 10:30

Slava Utesinov

13,410
2
19
26

Will it call to database only once and is it a fast way of doing that? – Ali Nafees Aug 29 '17 at 10:30
This would fetch the data from DB first, exactly the thing @Ali tries to avoid. – ViRuSTriNiTy Aug 29 '17 at 10:31
@AliNafees, yes it will not fetch data from database. You can read [this](https://github.com/zzzprojects/EntityFramework.Extended#batch-update-and-delete) – Slava Utesinov Aug 29 '17 at 10:32
@SlavaUtesinov It will not? Are you sure as .Where() is a condition and how should the library know which IDs are present without looking into the DB. – ViRuSTriNiTy Aug 29 '17 at 10:33
@ ViRuSTriNiTy I also have asked the same thing and let me check his link? – Ali Nafees Aug 29 '17 at 10:36
From documentation: Batch update and delete **eliminates the need to retrieve and load** an entity before modifying it – Slava Utesinov Aug 29 '17 at 10:37
Hey I have achieved that without using the Library and I would like to mark correct answer for the person who have said that do that by attaching first the entities. but thanks for your answer as well... – Ali Nafees Aug 29 '17 at 10:42
@AliNafees, attaching will work **only at case of Ids** filter, if you later will want to delete rows with custom filter, like `Where(x => x.Age > 20)`, it will not work. – Slava Utesinov Aug 29 '17 at 10:47
Yes but in this scnerio I was not needed to do for filtered first, and also I am avoiding installing the library first.main reason is I not want to install library – Ali Nafees Aug 29 '17 at 10:49

score 0 · Accepted Answer · answered Aug 29 '17 at 11:06

0

First create entities with new, assign the ID, then attach the entity like

db.People.Attach({your_entity_created_with_new})

and finally pass the entities to RemoveRange().

answered Aug 29 '17 at 11:06

ViRuSTriNiTy

5,017
2
32
58

2

But this only works for the Primery key and not for other properties in the class. but working fine... – Ali Nafees Aug 29 '17 at 11:34
With EF Core I didn;t even have to Attach(). RemoveRange() is sufficient – infografnet Aug 17 '21 at 14:09

.RemoveRange Without fetching database records first in Entity Framework

2 Answers2