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: 15010

Answer:

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

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

Bookmark It

< Previous : What’s the use of "GLOBAL.ASAX" file?

Next > : What is the diffeernce between Overload and Overri ...

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....!!!!!!

More Interview Questions by Kurmarao

Latest Interview Questions