Deleting multiple records at a time entities framework 5

Question

I created a MVC application using entity framework 5. I need to delete data from table using query. I have done one record delete, But now i have requiment to delete multiple records at a time.

My Table USER:
Id      Name     cityId
1       Rajesh      1
2       Rahul       1
3       Sulagna     1
4       Rajoshri    2
5       Deb         2

Now i need to delete where cityid = 1

Code which i have tried:

List<USER> listUser = new List<USER>();
listUser = db.USERs.Where(w => w.cityId == 1).ToList();
db.Entry(listUser).State = System.Data.EntityState.Deleted;
db.SaveChanges();

But its giving error.

I have searched and found a RemoveRange method to delete multiple records. But RemoveRange is not availabel in my project.

Answer 1

For EF5 you need to install EF extended library: EntityFramework.Extended after sucessfully installation try this below code.

var query = from c in db.USERs
                where c.cityId  == 1            
                select c;
query.Delete();

Answer 2

Try this:

foreach (var user in db.USERs.Where(u => u.cityId == 1).ToList()) { 
    db.USERs.Remove(user):
}
db.SaveChanges();

With EF6 it's easier:

db.USERs.RemoveRange(db.USERs.Where(u => u.cityId == 1));
db.SaveChanges();

Let me know if this helps,

Alberto

Answer 3

This would help to remove from the DB using Entity Framework:

Code: db.USERs.RemoveRange(db.USERs.Where(w => w.cityId == 1));