" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi
Here are some simple guidelines which can help you choose the one for your application.
When you do not need to cache the data (you don’t need operations like sorting, filtering on client side etc…)
Last but not the least:
The DataAdapter uses the DataReader while filling a DataTable. Hence, you get a performance gain by using DataReader instead of DataTable (DataAdapter).
1. In case of DataTable, as the whole data comes offline, hence it takes more amount of memory than using DataReader
2. No. of cycles the DataAdapter takes to fill up the data table.
Mail (will not be published) (required)
Enter Captcha Code *
eight − 2 =
Burn Ignorance is a knowledge initiative by Mindfire Solutions
Subscribe to our mailing list to get the updates to your email inbox...