Error connecting to Mysql using EF6

Question

I’m getting the bug

'System.Data.Strongtypingexception: The value for column 'Isprimarykey' in table 'Tabledetails' is Dbnull

Whenever I try to connect to a Mysql database using Entity Framework 6.

Any hint to fix?

Answer 1

With the links Virgilio Novic gave me,:

Stop the Mysql service;

Re-start the Mysql service;

Execute the following command:

use NOME_TABELA;
set global optimizer_switch='derived_merge=OFF';