What is the best data type to use for money in c#?

Question

What is the best data type to use for money in c#?

Answer 1

System.Decimal

The Decimal value type represents decimal numbers ranging from positive 79,228,162,514,264,337,593,543,950,335 to negative 79,228,162,514,264,337,593,543,950,335. The Decimal value type is appropriate for financial calculations requiring large numbers of significant integral and fractional digits and no round-off errors. The Decimal type does not eliminate the need for rounding. Rather, it minimizes errors due to rounding.

Answer 2

decimal

Answer 3

Decimal. If you choose double you're leaving yourself open to rounding errors

Answer 4

decimal has a smaller range, but greater precision - so you don't lose all those pennies over time!

Full details here:

http://msdn.microsoft.com/en-us/library/364x0z75.aspx

Answer 5

You might find answers from this post helpful.

Answer 6

Use the Money design patterns from Patterns of Enterprise Application Architecture; specify amount as decimal and the currency as an enum.

Answer 7

Create your own class. This seems odd, but a .Net type is inadequate to cover different currencies.

Answer 8

Agree with the Money pattern: Handling currencies is just too cumbersome when you use decimals.

If you create a Currency-class, you can then put all the logic relating to money there, including a correct ToString()-method, more control of parsing values and better control of divisions.

Also, with a Currency class, there is no chance of unintentionally mixing money up with other data.

Answer 9

Always decimal ... please decimal.. believe me.. always. sincere recommendation..regards.andy