Simon Mourier's Blog - Decimal precision codefluent

database

Decimal precision codefluent

Apr 22, 2016 See the question and my original answer on StackOverflow

You can use SQL Server Producer specific size and dataType attributes, like this:

<cf:property name="MyNumericProperty"
    typeName="decimal"
    cfps:size="6,2"
    cfps:dataType="numeric"
    xmlns:cfps="http://www.softfluent.com/codefluent/producers.sqlserver/2005/1"
/>

Note that, most of the time, decimal is also overkill in .NET (16 bytes).