Call SimpleQuery.ToScalar(). It throws an exception unless SimpleQuery contains one item with only one property in it.
Call SimpleRecord.ToScalar(). It just returns the scalar value for the first property.
Suggest : SimpleRecord.ToScalar() throws SimpleDataException if there are multiple properties in SimpleRecord like SQ.ToScalar().
Make ToScalar just return first value of first row; fixes issue #230
I went the other way, and made SimpleQuery more forgiving. Introducing a new exception could break existing code. Also, the prescribed behaviour of IDbDataReader.ExecuteScalar is to return the first value of the first row and ignore everything else, which would seem a good design cue.