Newbie: ADO.NET and thread safety

N

Navin Mishra

Hi,

I've multiple related data tables in a disconnected dataset which could be
accessed by mutltiple threads to read and write data. The documentation says
that dataset and datatable are thread safe to read in multithreaded
environment but one needs to lock them to update. Questions:

1) Is it not required to synchronize when searching data using Find, Select
and GetChildRows methods ?
2) Is it not required to synchronize when reading data using from returned
rows from above ?
3) When updating a row in a datatable, is it required to lock only datatable
or the whole dataset ?
4) Is ReaderWriterLock recommended in this disconnected scenario or using
Monitor/lock is "good enough" ?

Thanks in advance and regards

Navin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top