Truncating values

Radzen Blazor Studio
1

Hi

I have a little problem. I have used CRUD and in the database the four values that start with SRS are defined

[SRS] [numeric](4, 3) NULL,
[SRSWithOutHeadSail] [numeric](4, 3) NULL,
[SRSSH] [numeric](4, 3) NULL,
[SRSSHWithOutHeadSail] [numeric](4, 3) NULL,

When i store 1,001 it will be stored a 1,00 so the last digit is truncated. I have debuged and I can’t find what’s wrong

image
image597×816 28.6 KB

Is you can see that other boats have the right numbers, they are create with a stored procedure.

image
image1036×159 6.5 KB

2

Can you post the DbContext how HasPrecision() is defined for these properties and if they are mapped to decimal type in the model?

3

SailItV2DBContext.zip (1.2 KB)

Cant find HasPrecision in this file.

4

What version of RBS you have used to generate this DbContext?

5

Radzen Blazor Studie 1.61.0

6

What type is your database? Can you verify also if the mapped property is double or decimal?

7

Hi

SqlServer on Azure and the data type is decimal(4,3)

8

I’m asking the for the type of the C# property in your scaffolded model.

9 
    public decimal? SRS { get; set; }

    public decimal? SRSWithOutHeadSail { get; set; }

    public decimal? SRSSH { get; set; }

    public decimal? SRSSHWithOutHeadSail { get; set; }
10

Unfortuantely we cannot tell why there is no HasPrecision() genertated for these properties in the DbContext from the information provided so far. We will need your database schema (just schema, no data) in order to debug locally our scaffolding. Please zip and send the schema to info@radzen.com.

11

Ok will do that in a moment

12

TotScript.zip (3.0 KB)

13

We were able to identify and fix the problem - the fix will be part of our next update later the week!

14

Ok, thanks for that, when will the next version be ready

15

Before the end of the week.