Problems with decimal property

Question

Hi,

I have a really simple piece of code where I create new entity, set it's basic properties, add it to the context and call SaveChanges(). 

Everything works fine until I add additional line where I assign a value to the decimal type property (which is defined as a decimal(38, 30) column in database (SQL Server 2005)).

SaveChanges method gives me an error "Conversion overflows."

Anyone knows what could be the problem?

Answer 1

It seems that decimal(38, 30) is too big, because it works fine with the decimal(9, 2) property.

What is the max precision/scale I can use with SQL Server 2005 and Entity Framework (Visual Studio 2008 SP1)?

Thanks,

Anil

Answer 2

http://support.microsoft.com/kb/932288

"To resolve this issue, do not use a number that exceeds the precision limit of 28."

I changed all columns to decimal(28, 20) and now it works.