how to use data annotation for numeric value in database

Question

I got attribute in sql server 2012 database of data type numeric (18,0), how I am going to model using data annotation in asp.net mvc-5 app.

this code giving me following error...

An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code

Additional information: The 'PassMark' property on 'MarkScheme' could not be set to a  'System.Decimal' value. You must set this property to a non-null value of type 'System.Int32'

Many Thanks

SQL Image

enter image description here

Model

 [Required(ErrorMessage = "Required Pass Mark")]
 [Display(Name = "Pass Mark")]
 public int PassMark { get; set; }

KevDevMan · Accepted Answer · 2014-02-21 09:47:51Z

1

I would use the [RegularExpression]. like yzi_20004 but your issue is that you set

  public int PassMark { get; set; }

and it should be

    public decimal PassMark { get; set; }

hope this helps

answered Feb 21, 2014 at 9:47

KevDevMan

81811 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ramiramilu · Accepted Answer · 2014-02-21 10:32:03Z

1

Use following attribute for validation -

[Range(0, 999999999999999999)]

And your C# property should be -

Updated EDIT

public decimal PassMark { get; set; }

edited Feb 21, 2014 at 10:32

answered Feb 21, 2014 at 9:37

ramiramilu

17.2k6 gold badges51 silver badges66 bronze badges

3 Comments

ramiramilu Over a year ago

@toxic Can you share actual Range code you used? and what error you got?

ramiramilu Over a year ago

@toxic, have you used - [Range(0, 999999999999999999)]

K.Z Over a year ago

yes i did and i am getting following error... Additional information: The 'PassMark' property on 'MarkScheme' could not be set to a 'System.Decimal' value. You must set this property to a non-null value of type 'System.Double'.

yzi_20004 · Accepted Answer · 2014-02-21 09:35:47Z

0

I always using [RegularExpression("^[0-9]{0,18}$", ErrorMessageResourceType = typeof(Messages), ErrorMessageResourceName = "ErrMsg_ID")]

answered Feb 21, 2014 at 9:35

yzi_20004

11 bronze badge

Collectives™ on Stack Overflow

how to use data annotation for numeric value in database

SQL Image

Model

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

SQL Image

Model

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related