I am using ExecuteReader() for DataReader
SqlDataReader myReader = _database.ExecuteReader(myCommand);
and ExecuteDataSet() for DataSet.
DataSet myDataSet = _database.ExecuteDataSet(myCommand);
I read following Microsoft article regarding performance between ExecuteReader() and
It says, ExecuteReader() is better than ExecuteDataSet().
So can I use like
DataSet myDataSet = (DataSet)_database.ExecuteReader(myCommand);
(First I use ExecuteReader and convert as DataSet and assign to DataSet object)
Can I acheive the performance?
What is the advantage and disadvantage of this?
View Complete Post