Entity Framework

Question

Hello

I have too many decimal fields are in my system.When I save large value it will throw error "Coversion overflow".

Is there any way to handle error without changing model or db ? I want to show the message to user that please enter valid value for the fields.

I want to make generic so i do not want to write for each field.

awaiting for your reply

keyur · Answer

Can any one please help to resolve this issue?

Nanhe Siddique · Answer

hi keyur Check the target column size for each column where the value is computed by a formula. Consider either expanding the size of the target or r column educing the allowable values in the formula's source columns.

keyur · Answer

Thanks for the reply But I did not get enough idea from the link you given.Can you please tell how to achive this? Thanks

Munesh Sharma · Answer

http://www.outsystems.com/forums/discussion/8079/conversion-overflows-error-getting-a-decimal/ https://social.msdn.microsoft.com/Forums/en-US/a97e9bcd-b285-4670-9e61-acac4567db6a/conversion-overflow-error-while-mapping-large-decimal-value?forum=adodotnetdataproviders https://msdn.microsoft.com/en-us/library/system.data.sqltypes.sqldecimal.aspx

keyur · Answer

In database i have money datatype.how would i check restrict user to not add large value or show message please enter valid value