Edit and delete error in FirstOrDefault() postgresql

Radzen Studio Blazor Server
1

I have created a project with Radzen and Postgresql. Edit and delete rows of the tables don't work because
var items = context.Almacens
.AsNoTracking()
.Where(i => i.refe == refe);

        var item = items.FirstOrDefault();

always returns null.

2

You can start the project with Visual Studio and put a breakpoint in that method to check if the refe parameter has the right value and if there is a corresponding record in the database.

3

Thanks,

I have done it and the refe value was correct

4

This is very strange. Does editing work? I mean opening the edit page and getting an item loaded in the form? It uses GetXXXById which uses similar Entity Framework code.

5

Thanks Atanas,

Please, see in this image the error when click in ítem for edit:

debugger
debugger1920×1080 206 KB

6

The value is a string that ends with a lot of spaces. This is probably why it doesn't match.

7

Yes, that was the problem.
I have solved it by adding in the entity anotation::
[Column(TypeName = "char(16)")]