asp.net core model four decimal places validation

Question

In my model in asp.net core when I scaffold my database it only allows for a number with two decimal places like 0.10 but, I am not allowed to insert four decimal places into my database.

Below is my model.

     public class Order
{
    public int OrderID { get; set; }

    [RegularExpression(@"^\d+.\d{0,4}$", ErrorMessage = "Must have four decimal places")]
    [Range(0.0001, 1)]
    [Display(Name = "Goal Diameter Tolerance")]
     public decimal? GoalDiameterTolerance { get; set; }
}

Below is the GoalDiameterTolerance scaffolded. It only allows for two decimal places. I can change it but, how do I fix it before the scaffold in the model.

 GoalDiameterTolerance = table.Column<decimal>(type: "decimal(18, 2)", nullable: true),

It should scaffold to this I believe.

GoalDiameterTolerance = table.Column<decimal>(type: "decimal(18, 4)", nullable: true),

Here is how I solved my problem.

foreach (var property in modelBuilder.Model
            .GetEntityTypes()
            .SelectMany(t => t.GetProperties())
            .Where(p => p.ClrType == typeof(decimal) ||
            p.ClrType == typeof(decimal?))
            .Select(p => modelBuilder.Entity(p.DeclaringEntityType.ClrType).Property(p.Name))
            )
        {
            property.HasColumnType("decimal(18,4)");
        }

[DisplayFormat(ApplyFormatInEditMode = true, DataFormatString = "{0:#.####}")] is another possible way that will not work. — Alex Zimmerman, Sep 25 '17 at 20:33

score 0 · Answer 1 · answered Sep 25 '17 at 21:30

0

I do not think EF code generation tries to deduce the column type from Display\Validation attributes. You should be able to specify the desired column type explicitly using the Column attribute

Column(TypeName = "decimal(18, 4)")

Or by overriding OnModelCreating and customize your column type there

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
     modelBuilder.Entity<Order>()
            .Property(p => p.GoalDiameterTolerance)
            .HasPrecision(18, 4); 
}

answered Sep 25 '17 at 21:30

shurik

775
9
19

https://stackoverflow.com/questions/41468722/loop-reflect-through-all-properties-in-all-ef-models-to-set-column-type – Alex Zimmerman Sep 25 '17 at 21:40
I used the link above I will display the function above that I used. – Alex Zimmerman Sep 25 '17 at 21:41
Thank you. I could not find the ability to specify the column information in the model. – Alex Zimmerman Sep 25 '17 at 21:42

asp.net core model four decimal places validation

1 Answers1