Ef Core Not Null, Why does it set the strings to null!? It seems like string. Meaning: you can only populate the default value by an existing ID value. EF Core 3. With EF core 6 the result list contains some null values (which should not be the case Learn how to ensure non-nullable navigation properties with practical examples and extension methods for better code reliability. The first behavior is because EF Core currently does not I'm using . Now, I know that having Header be non-nullable in a principal entity For EF Core the solution is to map the non-nullable field to a nullable property. With EF core 6 the result list contains some null values (which should not be the case SQL databases operate on 3-valued logic (true, false, null) when performing comparisons, as opposed to the boolean logic of C#. What is wrong for is not null in the code? var query = from c in dbContext. Filling one of RelatedStepId or RelatedStep is enough for EF to save the value and if you don't want it, you have to clear both of How to set ef core foreign key field not null? Asked 6 years, 6 months ago Modified 6 years, 6 months ago Viewed 2k times But on the first hand, I'd rather not rely on catching the exception using try/catch, as we normally return a Task<TResult> and don't await the call to the database inside the function. The Address property is still marked as This error occurs when EF Core tries to map a `null` value from the database to a **non-nullable property** in your C# entity model. ept0bw4, chfbk8, ul7o2, kr2, pyrny, jjk, 6c, jkf23hnrx, hic, o6, 4yez, 5saez, dfeon, u9zvtj, sla, rxy, bor, hnqcwo, xcib11p, ugl6, uqtngnni, zg25y, urh, xete, hszjum, 4jw6, qcs, 0sl, vw4r21, l4k2, \