How can I validate that a value passed to a SqlParameter will not fail precision and Scale?

Asked Aug 20 '15 at 06:47

Active Aug 20 '15 at 06:54

Viewed 145 times

How can I validate that a value passed to a SqlParameter will not fail the Precision and Scale properties at the time of setting the value, rather than waiting for the "System.ArgumentException" to be thrown when ExecuteReader is called on my command object, so I can throw an ArgumentoutOfRange exception earlier in my code and fail fast?

Example

        Decimal myValue = 123456789.234M;

        SqlParameter parameter = new SqlParameter("MyParameter", SqlDbType.Decimal);
        parameter.Precision = 10;
        parameter.Scale = 2;
        /* I'd like to fail here at the line below as the value does not conform to precision and scale */
        parameter.Value = myValue;

edited Aug 20 '15 at 06:54

asked Aug 20 '15 at 06:47

Dib

2,001
2
29
45

Can you please show your work as well? – Soner Gönül Aug 20 '15 at 06:49
Could you make an extension method to validate the value? – cost Aug 20 '15 at 07:13
Are you asking how to [Calculate System.Decimal Precision and Scale](http://stackoverflow.com/questions/763942/calculate-system-decimal-precision-and-scale)? – Corak Aug 20 '15 at 07:16
@corak - yes that may be a better way of putting it. I'll read your link – Dib Aug 20 '15 at 07:19
1

@Corak - Just to confirm your link sent me in the right direction. – Dib Aug 23 '15 at 08:16

How can I validate that a value passed to a SqlParameter will not fail precision and Scale?

0 Answers0