Which ADO.NET object is very fast in getting data from database?

 Posted by Kurmarao on 6/17/2008 | Category: ADO.NET Interview questions | Views: 15597

SqlDataReader object. (Note: Even datasets also use SqlDataReader objects internally for retriving data from database.)

Source: own | Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Charan on: 12/5/2010 | Points: 10
SqlDataReader is fast reterive records from the database.. compare with dataset.
DataReader is forward and read only.
Posted by: Nareyugam on: 4/23/2012 | Points: 10
Datareader is faster than others
Posted by: Dhirajluhana on: 3/14/2013 | Points: 10
Datareader working on the connected architecture .... and it also lightweight..

So DataReader is faster than the Dataset....!!!!!!

Login to post response

More Interview Questions by Kurmarao