GetScalar() with nullable types throws exception with no results present.

[carstenlj]

When provding a nullable type in the GetScalar method, It would be nifty if the method didn't throw an exception in case of no rows, but instead returned a null. This seems to be the behavior as well of the standard .Net SQL client.

[improvedk]

So if you call GetScalar<int?>() you want it to be null if there's no results? How would you distinguish that from a result that provided an actual null value?