datareader - Handle DBNull in C#

Question

Is there a better/cleaner way to do this?

int stockvalue = 0;
if (!Convert.IsDBNull(reader["StockValue"]))
    stockvalue = (int)reader["StockValue"];

question from:https://stackoverflow.com/questions/2433155/handle-dbnull-in-c-sharp

Answer 1

The shortest (IMHO) is:

int stockvalue = (reader["StockValue"] as int?) ?? 0;

Explanation:

• If reader["StockValue"] is of type int, the value will be returned, and the "??" operator will return the result
• If reader["StockValue"] is NOT of type int (e.g. DBNull), null will be returned, and the "??" operator will return the value 0 (zero).