ExcelDataReader/ExcelDataReader — pull request #30 by Swiftam (2014-10-21 02:57:34+00:00)
Title: Boxing Non-Nullable Types When Copying into a DataSet

Using this under .NET 4.5 (Mono), IExcelDataReader.AsDataSet would fail with a NullPointerException when a non-nullable data typed column encountered a null value.

For example, the following CSV would result in a DoubleDataContainer.DoCopy Null Pointer Exception:

"1","List Item One",
"","List Item Two"

Because the first column was typed "double", but the second row had an empty value.

The platform appropriate solution was to convert the identified type (T) to Nullable.

Maybe the MS .NET framework is more lenient for DBNull values inside data sets, or does the wrapping automatically? I don't have access to Visual Studio so wasn't able to add a test case for this.