SqlProviderServices.TruncateDecimalsToScale Property


Get or sets a value indicating whether Decimal parameter values are truncated to the scale (number of decimal places) defined for their corresponding columns when they are sent to the database. A value of true indicates that SqlParameter objects created for Decimal columns will have their Scale properties set, which will cause the parameter values to be truncated. If set to false then the Scale properties will not be set, avoiding the truncation behavior of SqlParameter and allowing SQL Server to round values if necessary. The default value is true to prevent breaking existing applications that depend on this behavior.

public static bool TruncateDecimalsToScale { get; set; }
member this.TruncateDecimalsToScale : bool with get, set
Public Shared Property TruncateDecimalsToScale As Boolean

Property Value


Applies to