Exception on nullable foreign key

Radzen IDE (Angular)
1

I have in MSSQL a nullable foreign key in a table
In radzen console i got the following exception:

Microsoft.OData.ODataException: The property ‘CategoryID[Nullable=False]’ of type ‘Edm.Int32’ has a null value, which is not allowed

The ‘categoryID’ is defined as nullable in mssql

2

Hi Bart,

We will do our best to provide fix for this soon!
Thank you very much for the report!

Best Regards,
Vladimir

1 Like
3

Hi Bart,

Unfortunately we were unable to replicate the exception. Do you get this during read or update/delete? Can you send us (at info@radzen.com) your SQL schema (create script for schema only) to test locally what’s going on?

Thank you in advance!

Best Regards,
Vladimir

4

Hi Bart,

We’ve fixed the problem and the fix will be part of our next release and the internal build related to this thread.

Best Regards,
Vladimir

1 Like