.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
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