Hi all,

In Microsoft Mocs, they say that Data Reader is faster than DataAdapter becasue Data Reader holds one record in memory while data adapter caches all records in memory.


The question is, If i am looping thru records thru a datareader, and i am doing a kind of lenghy job. Will the table i am accessing be locked as long the reader is opened ??? In this way the data adapter will be more effecient as it will load all data once and free the table. All manipulation will be on client machine and not the server.

This question is very important as it is required to design the startegy of building my new DB Application.