Convert .net decimal to tsql decimal (3.3)

Question

I have a stored procedure that gets the decimal value (3.3) as a parameter. So, when I try to pass this parameter like this

new SqlParameter { ParameterName = "@Wear", SqlDbType = SqlDbType.Decimal, Value = wear.WearValue } 

I get

Error converting data types from numeric to decimal.

This exception occurs when I try to pass a value of 1.0. I need to convert 1.0 exactly to decimal(3,3) . How can i do this?

Answer 1

The maximum decimal(3,3) value decimal(3,3) will be 0.999 , so when you try to insert something more than this exception. try something like decimal(4,3)