Converting datareader value

[Toska]

Which method is the most effective.


-
bool b = (bool)dr["column"];
-
bool b = Convert.ToBoolean(dr["column"]);
-
bool b = dr.GetBoolean(0);
-
Other.

 

[sloan]

The pdf doesn't exist anymore, but I had this commented in my code:

//''FROM http://www.stevearnott.com/DAAG.pdf
// 'When accessing data by using the reader, use the typed
accessor methods (such
// 'as GetInt32 and GetString) if you know the column's
underlying data type
// 'because they reduce the amount of type conversion required
when you read
// 'column data.