EF Core 6 Decimal precision warning

Question

After upgrading to EF Core 6, I have this annoying warning here when adding a migration:

No store type was specified for the decimal property '{property}' on entity type '{entityType}'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values in 'OnModelCreating' using 'HasColumnType', specify precision and scale using 'HasPrecision', or configure a value converter using 'HasConversion'.

which is defined here: https://github.com/dotnet/efcore/blob/main/src/EFCore.SqlServer/Properties/SqlServerStrings.Designer.cs

I am not sure to understand the purpose of this warning because on entities with the tag [Keyless] as they do not live in the database. Also adding an attribute such as [Column(TypeName = "decimal(28, 6)")] doesn't seem to clear the warning on keyless entities.

score 21 · Accepted Answer · answered Apr 08 '22 at 15:24

21

Apparently there's a new attribute for EF Core 6:

using Microsoft.EntityFrameworkCore;

...

[Precision(18, 2)]

answered Apr 08 '22 at 15:24

Ryan Naccarato

674
8
12

1

That's great thank you, indeed the requirement for HasPrecision corresponds to the tag [Precision(18, 2)] and not [Decimal(18, 2)] – sofsntp Apr 11 '22 at 12:35
Thanks for this tip. Helped me greatly! – Vikingslord Mar 03 '23 at 17:25

EF Core 6 Decimal precision warning

1 Answers1