I need to create a property in a CF Orm entity that stores currencies (dollars and cents). For example: 100.99 or 1.30 etc. I have traditionally used decimal to store currencies as you can foce the number of decimal points, but there is no ORM property type for decimal, only float. I tried setting scale=2, but (for example) 1.30 was being stored as 1.3, or 5.00 is stored as 5.
Can anyone suggest the optimal way to work with currencies (having 2 decimal places) using CF ORM?
Many Thanks