Entity Framework remove a number of records

Question

Entity Framework delete a number of records

using (Galway__Entities db = new Galway__Entities())
{
    DateTime RemovableDate = new DateTime();

    List<PROJ_ACCS_StockControl_DeletedPLURecord> DeletedPLURecords = db.PROJ_ACCS_StockControl_DeletedPLURecord.Where(x => x.TimeStamp <= RemovableDate).ToList();

    db.??????
    //so I delete the list all at once or use a foreach and run round each record?
    //how do I delete each singular record if this is the case then.
}

If you are using EF6, check [this question](http://stackoverflow.com/questions/21568479/how-can-i-delete-1-000-rows-with-ef6). There is suggested to use `RemoveRange` method. — alexmac, Mar 27 '14 at 11:23

score 2 · Answer 1 · answered Mar 27 '14 at 11:37

2

You could use:

DeletedPLURecords.ForEach(element => db.PROJ_ACCS_StockControl_DeletedPLURecord.Remove(element));
db.SaveChanges();

answered Mar 27 '14 at 11:37

neel shah

2,231
15
19

score 1 · Answer 2 · answered Mar 27 '14 at 11:40

Try this:

 using (Galway__Entities db = new Galway__Entities())
    {
      DateTime RemovableDate = new DateTime();
      List<PROJ_ACCS_StockControl_DeletedPLURecord> DeletedPLURecords = db.PROJ_ACCS_StockControl_DeletedPLURecord.Where(x => x.TimeStamp <= RemovableDate).ToList();

      foreach (var item in DeletedPLURecords)
      {
          var e = db.PROJ_ACCS_StockControl_DeletedPLURecord.Find(item.Id);
          if (e != null)
          {
               Db.PROJ_ACCS_StockControl_DeletedPLURecord.Remove(e);
          }
      }
      db.SaveChanges();
    }

score 0 · Answer 3 · answered Mar 27 '14 at 11:52

currently to remove multiple records you need to first get records in memory then remove them. another solution is that you can use EntityFramework.Extended library to make this a single request process. like

....
db.PROJ_ACCS_StockControl_DeletedPLURecord.Where(x => x.TimeStamp <= RemovableDate).Delete();

Entity Framework remove a number of records

3 Answers3