Problem with connector / entityframework
Im creating a litle app using visual studio 2022, net 6 and mariadb, for study purposes, and i have a problem with mariadb where i receive a message that Object cannot to be cast to DBNull to other types. The problem appear to be this one related here
as i have testes with an older version of mariadb, prior to 10.10, and it works well. But i cannot solve it anyway and i cant use a previous version of db. I started my db in Mysql 8 and it worked as well, but where i planning to publish my app does install only a newer version of mariadb.
Does anyone once have this problem? Any suggestion what i can do?
Answer Answered by Vladislav Vaintroub in this comment.
It is known, and there was https://jira.mariadb.org/browse/MDEV-31608 filed for that. If you can vote for it, and comment, so it gets more attention and gets prioritized.
One workaround that was proposed is to get rid of MySql.Data and its entity framework support, and replace them with MySqlConnector, and entity framework by Pomelo.