1

I working with a big database what is the best way in performance -connected mode or disconnected mode- should I use?

rahularyansharma
  • 11,156
  • 18
  • 79
  • 135
VuState
  • 23
  • 2
  • 5
  • Duplicate of http://stackoverflow.com/questions/1083193/whats-better-dataset-or-datareader. do check duplicates for posting. – Ravi Gadag Oct 10 '11 at 04:01

1 Answers1

0

quoted from the post specified above: What's better: DataSet or DataReader?

It depends on your needs. One of the most important differences is that a DataReader will retain an open connection to your database until you're done with it while a DataSet will be an in-memory object. If you bind a control to a DataReader then it's still open. In addition, a DataReader is a forward only approach to reading data that can't be manipulated. With a DataSet you can move back and forth and manipulate the data as you see fit.

Hope this helps

Community
  • 1
  • 1
sys_debug
  • 3,883
  • 17
  • 67
  • 98