Decimal field format in ASP.NETCore model

Question

In SQL Server I have a primary key of a Table declared as follow :

[CustomerID] [numeric](18, 0) IDENTITY(1000000,1) NOT NULL,

In ASP.NET Core 2.2 model i mapped this field ad follow :

public decimal CustomerId { get; set; }

How can I make the decimal digits not appear in the application?

When you have a decimal value there is always the decimal digits in it, you have to format it before displaying. basically the representation of that value can be changed according to the formatting. — Siavash Rostami
– Siavash Rostami, Commented Oct 4, 2019 at 9:03
@Siavash : It isn't possible to do something with annotations? — Simone Spagna
– Simone Spagna, Commented Oct 4, 2019 at 9:07
of course, it is, that formatting can take place anywhere. I see there is already an answer using annotations. — Siavash Rostami
– Siavash Rostami, Commented Oct 4, 2019 at 14:33

LazZiya · Accepted Answer · 2019-10-04 09:30:30Z

1

Use DisplayFormat attribute:

[DisplayFormat(DataFormatString = "{0:0}", ApplyFormatInEditMode =true)]
public decimal CustomerId { get; set; }

answered Oct 4, 2019 at 9:30

LazZiya

5,7992 gold badges29 silver badges42 bronze badges

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

Comments

wolmi · Accepted Answer · 2019-10-04 09:52:41Z

0

If you only need to display it without decimal places, then the formatting can be applied with a ToString anywhere, preferably where you are trying to display it. The code below will apply rounding.

CustomerId.ToString("0");

If you need to use it in some other capacity without the decimal points then you should map your model representing the database table to another model specific to what you are trying to do and supply the correct type in that model. Probably an int or string in this case.

edited Oct 4, 2019 at 9:52

wolmi

1,71912 silver badges25 bronze badges

answered Oct 4, 2019 at 9:40

Jamie Wright

274 bronze badges

Collectives™ on Stack Overflow

Decimal field format in ASP.NETCore model

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related