Do you really need a SqlDataReader or OleDbDataReader?

Why not return the base class DbDataReader or the IDataReader interface from your method and then you can work on either. DataReader typically has no specializations for the specific database dialect it uses so there's nothing gained by explicitly using the specific versions.

+++ Rick ---

>Hi,
>
>I have a method that needs to return either OleDbDataReader or SqlDataReader (depends on the back-end database). Within the method I have IF/ELSE where the code is processed accordingly. But in the method signature I can only specify one type of reader. E.g.
>

>public OleDbDataReader MethodName()
>or
>public SqlDataReader MethodName()
>

>
>Does it mean that I have to split the method into two methods depending on the type of reader I need to return and deal with it at the calling level?
>
>TIA.