C#•8mo ago

EF Core HasPrecision()

Has anyone ever defined precision for decimal numbers in EF Core without using attributes? Even defining the value for some reason is truncated at "decimal(18,2)" when I do the migrations.

10 Replies

Samuel DuarteOP•8mo ago

builder
  .Property(transfer => transfer.Amount)
  .HasColumnType("decimal")
  .HasPrecision(14, 2);

# Migrations code generated

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

builder
  .Property(transfer => transfer.Amount)
  .HasColumnType("decimal")
  .HasPrecision(14, 2);

# Migrations code generated

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

leowest•8mo ago

worked for me using postgresql

leowest•8mo ago

Jimmacle•8mo ago

you can also specify the column type directly as decimal(x,y)

leowest•8mo ago

I didn't even need to specify the columntype on my first try efcore automagically did its work I wonder if his issue is a version/db issue

Samuel DuarteOP•8mo ago

I used SqlServer and still the precision is not defined

leowest•8mo ago

and what is the version of the efcore nuget you're using?

Samuel DuarteOP•8mo ago

<PackageReference Include="Microsoft.EntityFrameworkCore" Version="8.0.2" />
<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.2" />

<PackageReference Include="Microsoft.EntityFrameworkCore" Version="8.0.2" />
<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.2" />

leowest•8mo ago

yeah I cannot reproduce it sorry maybe some one else knows about it

Gaming

Programming

EF Core HasPrecision()