.NET Decimal = what in SQL?

Posted by dmose on Stack Overflow See other posts from Stack Overflow or by dmose
Published on 2008-10-23T15:11:18Z Indexed on 2010/03/08 23:06 UTC
Read the original article Hit count: 304

Filed under:
|

What's the best data type in SQL to represent Decimal in .NET?

We want to store decimal numbers with up to 9 decimal place precision and want to avoid rounding errors etc on the front end.

Reading about data types, it appears using Decimal in .NET is the best option because you will not get rounding errors, although it is a bit slower than a Double.

We want to carry this through down to the DB and want minimum conversion issues when moving data through the layers. Any suggestions?

© Stack Overflow or respective owner

Related posts about sql

Related posts about .NET