[SOLVED] Entity Framework Core: `SqlNullValueException: Data is Null.

Veröffentlicht am: 22 Februar 2022
auf dem Kanal: KDTechs

2,882

This video is about how to troubleshoot Entity Framework core Error SqlNullValueException: Data is Null. This method or property cannot be called on Null values.

The error message indicates that EF Core is trying to read string value for a required property, i.e. a property which should never have null value in the database, but instead the underlying data reader reports null value for that property in some record(s).

Looking at your entity model and corresponding database table, you can see the obvious discrepancy for many string properties varchar columns. CompanyStreetAddress, CompanyCity, CompanyZipCode, CompanyVatNumber, ContactFirstName, ContactLastName - all these are marked as [Required] in the model, bit have no corresponding not null constraint in the table.

So the problem is caused by one or more of these columns.

You need to fix that discrepancy - probably by removing [Required] attribute because the constraint is already broken in the existing data.

The fact that it "works" in some older EF Core version doesn't matter - that's incorrect mapping and as such should be fixed. Technically it shouldn't worked from the beginning. But remember that EF Core is still in active development and has many bugs which are fixed in the next release(s). Most likely some code change was made between "working" and "non working" EF Core version which fixes the previous incorrect behavior.

Auf dieser Seite können Sie das Online-Video [SOLVED] Entity Framework Core: `SqlNullValueException: Data is Null. mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer KDTechs 22 Februar 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 2,882 Mal angesehen und es wurde von 11 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

274