Any Column that has a name that start with 'Names' can reproduce this issue.
It is easier to reproduce in dbForge so I will first provide steps for that:
1. Create a schema test
2. Create a table
Code: Select all
CREATE TABLE test.test (
Id int UNSIGNED NOT NULL AUTO_INCREMENT,
Names2 bit(1) DEFAULT NULL,
PRIMARY KEY (Id)
)
ENGINE = INNODB,
AUTO_INCREMENT = 2,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_0900_ai_ci;
4. Run the following query (This query was extracted from the Entity Framework debugging message) :
Code: Select all
UPDATE test.test set Names2 = 0
WHERE Id = 1;
where id = 1' is not supported"
The same can be reproduced in Entity Framework in .NET Core 3.1 using the mentioned Devart.Data.MySql.EFCore. That is how I found this issue initially and when I tried to reproduce it in dbForge saw the same issue there. That query works in Workbench.
In Core it would be something like:
Code: Select all
var item = dbCtx.Test.FirstOrDefault();
item.Names2 = 0;
dbCtx.SaveChanges();
Interesting enough in dbForge if you quote the name you can work around it. I have not seen a similar option for Entity Framework.