Unexpected 'how to insert the value NULL into column' scenarios when updating entities with Entity Framework Core 5
I tried several approaches but none seem to work... I'm working with an scenario when trying to update an entity in my EF Core 5 application. I have a simple model that includes a nullable property, but I keep getting the behavior: `want to insert the value NULL into column 'ColumnName', table 'Database.dbo.TableName'; column does not allow nulls. UPDATE fails.` Despite the property being nullable, it seems EF is trying to insert a NULL value during the update operation. Here's my model: ```csharp public class MyEntity { public int Id { get; set; } public string Name { get; set; } public string? Description { get; set; } // This is nullable } ``` When I fetch the entity from the database using: ```csharp var entity = await _context.MyEntities.FindAsync(id); ``` And then update the Description property like this: ```csharp entity.Description = null; _context.MyEntities.Update(entity); await _context.SaveChangesAsync(); ``` I expected it to work since 'Description' is nullable, but it fails with the behavior above. I've also tried explicitly setting it to `DBNull.Value` before calling `SaveChangesAsync()`, but that didn't resolve the scenario. I have verified that my database schema allows this field to be null, and I've checked the generated SQL query in the logs which shows that EF is indeed trying to update the Description to NULL. It seems like there might be a tracking scenario or something related to state management. I would appreciate any insights or suggestions on how to resolve this while ensuring that the property can remain nullable in my model. For context: I'm using C# on macOS. Am I missing something obvious?