C#•10mo 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•10mo 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•10mo ago

worked for me using postgresql

leowest•10mo ago

Jimmacle•10mo ago

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

leowest•10mo 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•10mo ago

I used SqlServer and still the precision is not defined

leowest•10mo ago

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

Samuel DuarteOP•10mo 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•10mo ago

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

Gaming

Programming

EF Core HasPrecision()

Did you find this page helpful?