EF joins MySQL table ' tabledetails ' in the value of column ' IsPrimaryKey ' to DBNull

The model cannot be generated because the following exception exists: ' System.Data.StrongTypingException: The Value of column ' IsPrimaryKey ' in table ' Tabledetails ' is DBNull. ---> system.invalidcastexception: The specified conversion is not valid.

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

Original:

Entity Framework (Version 6.1.3) and MySQL Server (>= 5.7.6)

One-to-resolve the issue is,

1. Open Services (Services.MSc) andRestartMySQL57 Service2. execute the Following commands in mysql. use <<database name >>;  set global Optimizer_ Switch= ' Derived_merge=off ' ;3. update the .edmx             

It ' s a late reply. But hope it would help somebody.

Thanks.

Approximate translation:

1. Restart the MySQL service

2. Open the Command column interface

 set global optimizer_switch< Span class= "pun" >= ' Derived_merge=off ' ;        

3. Re-create EF

EF joins MySQL table ' tabledetails ' in the value of column ' IsPrimaryKey ' to DBNull