I have a column inside my sql server 2008 wih type of Decimal(18,2)
. But on entity framework what is the best data annotation validation I can apply to this property, inside my asp.net MVC web application ?
I have a column inside my sql server 2008 wih type of Decimal(18,2)
. But on entity framework what is the best data annotation validation I can apply to this property, inside my asp.net MVC web application ?
There is no explicit data annotation for a decimal so you need to use two separate ones to add constraints.
[RegularExpression(@"^d+(.d{1,2})?$")]
This regular expression will make sure that the property has at most two decimal places.
[Range(0, 9999999999999999.99)]
Assuming you aren't accepting any negative numbers. Otherwise, replace 0
with -9999999999999999.99
.
[RegularExpression(@"^d+(.d{1,2})?$")]
[Range(0, 9999999999999999.99)]
public decimal Property { get; set; }