DataSet OR DataReader for this case

Question

I have a need to iterating through 2 tables, first iterate 1 tables and based on its value fetch and iterate the other table. It likes

GetAllEmployeeName

For each employee get and iterate All Sub Employees and do some OPERATION.

Now I am using ADO.NET for this fetching and keeping data.

Since my data are huge i.e the sub-employee are many(around 10,000) to one employee.

And the operation I am doing is quite time taking i.e it also make a web service call for each sub employee.

Should I keep them in a DataSet or SqlDataReader for my case, considering performance and no database locking..

There will **always** be database locking - you cannot totally avoid that. — marc_s, Oct 22 '13 at 13:56
USing DataSet...I dont think we are locking..it will be a one time lookup only.. — Akon, Oct 22 '13 at 13:57

score 0 · Answer 1 · edited May 23 '17 at 10:31

0

If you just need to load data, use SqlDataReader. SqlDataAdapter/DataSet allows you to iterate both forward and backward the result, as well modify it. Also, see this: SqlDataAdapter vs SqlDataReader

edited May 23 '17 at 10:31

Community

1
1

answered Oct 24 '13 at 21:39

Doro

671
1
16
34

DataSet OR DataReader for this case

1 Answers1