An exception occurred with the EF build model: The Value of column "IsPrimaryKey" in Table "Tabledetails" is DBNull workaround

When the Entity framework connects to MySQL: The model cannot be generated because of the following exception: The value of column "IsPrimaryKey" in table Tabledetails is DBNull.

When the above error occurs, consider connecting to the target database and executing the following SQL statement:

 1  --  Execute the following commands in MySQL.  2  3  use  <<  database  name>>  ;  4  5  set  global Optimizer_switch=   " derived_merge=off   "  6  7  --   set optimizer_switch= ' Derived_merge=off ';  

Http://stackoverflow.com/questions/33575109/mysql-entity-the-value-for-column-isprimarykey-in-table-tabledetails-is

When the above command execution is still invalid, restart the MySQL service in the service, execute the above SQL statement and then try to update the model from the database;

An exception occurred with the EF build model: The Value of column "IsPrimaryKey" in Table "Tabledetails" is DBNull workaround