asp.net - Best way to check SQLDataReader before reading -

i reading data db using sqldatareader. best way check, before reading data. 1 best out of 3

method 1

 using (sqldatareader objreader = sqlcommand.executereader())                     {                         if (objreader != null)                         {                             while (objreader.hasrows && objreader.read())                             {                                 //code                             }                         }                     } 

method 2

                using (sqldatareader objreader = sqlcommand.executereader())                     {                         if (objreader != null)                         {                             while (objreader.read())                             {                                 //code                             }                         }                     } 

method 3

               using (sqldatareader objreader = sqlcommand.executereader())                     {                              while (objreader.hasrows && objreader.read())                             {                                 //code                             }                      } 

afaik sqlcommand.executereader never returns null. can throw various excpetions it's never null. check redundant.

you don't need check if hasrows in every loop iteration. information useful @ beginning , not every time. not necessary. won't errors if try read records when there none.

so i'd prefer(opinion-based) this:

using (sqldatareader objreader = sqlcommand.executereader()) {     if(objreader.hasrows)     {         while (objreader.read())         {             //code         }     }     else     {       // output/ log this?      } }