I know that
IDataReader
DataReader
Datareader
IDataReader
SqlDataReader
and all other data providers implement IDataReader
. If you think that you may change the provider from sql to oracle or something else in future then use IDataReader
. You will have the luxury of changing that without changing your code where you have used IDataReader
. Else you can use SqlDataReader
. But if you use IDataReader
it will be a decoupled design and is recommeneded.