C# DataTable.Rows.Clear() not clearing rows [duplicate]

Question

I have a DataSet dsComponents that embraces many tables, all of them are only in-memory, I don't sync them with any database. At some moments I need to remove all rows to free some memory but the function seems not to working (based on this answer)

if(dsComponents.Tables.Contains("MemoryHistory"))
{
  dsComponents.Tables["MemoryHistory"].Rows.Clear();
}

But if I break right after this code it shows that there still all rows in the table. I also tried:

if(dsComponents.Tables.Contains("MemoryHistory"))
{
  lock(dsComponents.Tables["MemoryHistory"])
  {
    foreach (DataRow row in dsComponents.Tables["MemoryHistory"].Rows)
    {
      row.Delete();
    }
  }
  dsComponents.Tables["MemoryHistory"].Rows.Clear();
}

and this one fails with "Collection was modified; enumeration operation may not execute", even with the lock. So, how to clear the rows of the table but preserve the table itself (like its Primary key, etc...)?

Answer 1

The issue here is that your are modifying an Enumerable as you are iterating over it which is not allowed.

You need to reset the rows property on the table without iterating over the rows.

Think about like iterating over a List<T>

You would not do

foreach (var element in list)
{
    list.Remove(element);
}

Instead you would do something like:

list.Clear();

In your case you would want to do

dsComponents.Tables["MemoryHistory"].Rows.Clear();

I am not sure of your need for the lock object, but if you clarify that, I would be happy to modify my answer.

Answer 2

Just do

dsComponents.Tables["MemoryHistory"].Clear();