使用EntityFramework批次刪除資料

使用EntityFramework批次刪除資料

using (EntitiesContext db = new EntitiesContext(connString))
{
    // Retrieve all records from database for deletion
    IEnumerable<entity> entityList = db.entity.where(x => x.id == id).toList();
    
    // Use Remove Range function to delete all records at once
    db.entity.RemoveRange(entityList);
    
    // Save changes
    db.SaveChanges();
}