Converting a nullable object to an integer

  1  int convertedInteger;
  2  object someValue; // Can be anything
  3  
  4  // The conversion
  5  Nullable<int> converted = someValue as Nullable<int>
  6  // Or shorter
  7  int? converted = someValue as int?;
  8  
  9  convertedInteger = (converted.HasValue) ? converted.Value : -1;

  1  int storedProcedureResult = -1; // Default value is -1
  2  
  3  using (SqlCommand cmdMatch = new SqlCommand("spName", Connection))
  4  {
  5    cmdMatch.CommandType = System.Data.CommandType.StoredProcedure;
  6    int? result = cmdMatch.ExecuteScalar() as int?;
  7    storedProcedureResult = (result.HasValue) ? result.Value : -1;
  8  }

  1  int storedProcedureResult = -1; // Default value = -1
  2  
  3  using (SqlCommand cmdMatch = new SqlCommand("spName", Connection))
  4  {
  5    cmdMatch.CommandType = System.Data.CommandType.StoredProcedure;
  6    var converted = cmdMatch.ExecuteScalar() as int?;
  7    int storedProcedureResult = converted ?? -1;
  8  }

  1  
  2  // This block is marked red because this is NOT the correct way
  3  int storedProcedureResult = -1; // Default value is -1
  4  
  5  using (SqlCommand cmdMatch = new SqlCommand("spName", Connection))
  6  {
  7  
  8    cmdMatch.CommandType = System.Data.CommandType.StoredProcedure;
  9    object result = cmdMatch.ExecuteScalar();
 10    if (result != null)
 11    {
 12      int.TryParse(result.ToString(), out storedProcedureResult);
 13    }
 14  }