O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Q&A

Q1: If I have to update data changed by the end user, is it better to use a DataReader and apply the changes myself, or should I use the DataAdapter and the associated hit in performance?
A1: This is a close call and depends very much on the requirements of your application. If you need to squeeze out every last bit of performance, you'll want to use the DataReader and perform manual updates. Otherwise, the benefits gained by using the DataAdapter object to automatically reconcile changes to the data will far outweigh the performance gains of the DataReader object.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required