Working with cached DataTables ?

[devboycpp]

In a website a DataTable is stored as an entry in the Cache object. On each page load some rows from the table may be removed based on some criteria and also RowFilter property of its default view is manipulated and some fields of the table are set. The question is as the DataTable object and DataView object are not thread safe for write operations ,what is the best way to prevent simultaneous changes to the table stored in cache. lock statement ? is it an expedient way ? or copying the table stored in cache and doing writes on that ?... A good advise from an erudite programmer is welcomed. Thanks in advance .

[jkirkerx]

That's a complex question. To the best of my knowledge, you can only cache html, css or webforms, and that data is not cached by the web server - IIS6, 7 or 7.5 As far as threads goes, that depends on the app pool settings you choose for the website on the webserver. Classic or Integrated. If your using SQL Server, or even MySQL, the data will be written, and the cache will be updated upon a write.