I’m encountering an issue with Entity Framework Core (using Pomelo for MySQL) in my .NET Core 6 application. When I update or recreate the database, a specific field (OperationCode) in my XXX table is automatically assigned a default value of a single double-quote (“). This property is not null, and I’ve used the same code for some other fields in another table, where it is working fine.
Model
public string Tag { get; set; } = null!;
Context
`
entity.Property(e => e.Tag)
.HasColumnType("varchar(50)")
.HasColumnName("tag"); `
Column
Why is the OperationCode field in the XXX table being set to a default value of a single double-quote (“), and how can I prevent this from happening?
Any insights or solutions to this problem would be greatly appreciated.