Delete multiple rows using Entity Framework

Question

When deleting data related to an object in an HttpDelete call using Entity Framework Core, I can do this:

var video = _context.VideoList.Where(x => x.VideoId == nodeList.VideoId).FirstOrDefault();

But what if I have multiple rows that needed deleted using the same VideoId? Also the two entities are not related in the database(no foreign keys).

I've found answers that use a List then use RemoveRange, but I just need to delete potentially multiple records using the same ID...I know in SQL it would look like this:

DELETE FROM VideoList WHERE VideoId = '111xxx333aaa'

Is there a way to do this in EF core?

Thanks!

geosom · Accepted Answer · 2020-09-16 22:22:08Z

1

You can do it in 2 steps :

Even if your entities are not related get them in an IEnumerable like a List

var videos = _context.VideoList.Where(x => x.VideoId == nodeList.VideoId).ToList();

And then remove them with a RemoveRange

_context.VideoList.RemoveRange(videos);

answered Sep 16, 2020 at 22:22

geosom

361 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Delete multiple rows using Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related