data-types.jpg

<div>
<b>your probably safe with either one.. I always recommend if your talking about a currency value to use Decimal though :)</b>
</div>


your probably safe with either one.. I always recommend if your talking about a currency value to use Decimal though :)

<div>
I am wondering if the precision of 2 decimal places would make double a better candidate.
</div>


I am wondering if the precision of 2 decimal places would make double a better candidate.

<div>
I would go with decimal there as well
</div>


<div>
<div class="content wysiwyg-content">
Hello all,<br />
<br />
We have a database that was using floats for many fields that we are changing to Decimal(18, 2). &nbsp; &nbsp;Question is in C# app code we use Double everywhere. &nbsp;Best to change these now to Decimal datatype or leave as is and double will be fine?
</div>
</div>


Hello all,

We have a database that was using floats for many fields that we are changing to Decimal(18, 2).    Question is in C# app code we use Double everywhere.  Best to change these now to Decimal datatype or leave as is and double will be fine?

C# Decimal or Double for Database Decimal

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).