In my code-first entity framework sql database I have a decimal value specified as 18,3. Database object:
public decimal? Kolhalt { get; set; }
In OnModelCreating I have
modelBuilder.Entity<Skada>().Property(o => o.Kolhalt).HasPrecision(18, 3);
In the database the value is specified as Kolhalt (decimal(18, 3), null)
If I enter a value directly in the database I get three decimals, but when I insert or update a value with EntityFramework it is truncated to 2 decimal places.
With Sql server profiler I can see that EF specifies 2 decimals for the stored value:
[Kolhalt] = @14 ... @14 decimal(18,2) ... @14=5.12
(The entered value was 5.123).
So for some reason EF truncates the values sent to the database when I call SaveChanges().
Do I have to specify the number of decimals someplace else to get it right in SaveChanges()?
Best regards, Henrik