What are the pros and cons of each?
If you are concerned about resource locks occurring on the databases, which is the best for minimizing it?
I understand Datareaders and Datasets are 'opposing' ways to access a database. Are databinding / linq dependent on datareaders and datasets from an 'under the hood' perspective or do they have their own separate ways of operating? I understand databinding
is basically tying a table to an object.
Basically I want to know how efficient the various methods are, how they deal with locking resources on the database (persistent connections) and how much each technology 'under the hood' actually relies on something else at a lower level.
edit: one more questions - if one was trying to design web services, how would the choice of connection methodology matter?
Go to the complete details ...