The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull

Video Tutorial

In this tutorial we will learn how to fix The value for column 'IsPrimaryKey' in table 'TableDetails' is DBNull error while adding ado.net Entity Data Model.


1- In  below Image i have show that error which occurs during adding ado.net Entity Data Model.

2- Now go to the following Address"Start->All Program->MySQL->MySql Server 5.7 ->MySQL Command Line Client".
3- Run the MySQL Command line Client and Enter your MySql Server Connection Password.
4- Paste Follow Code.

set global optimizer_switch='derived_merge=off';
set optimizer_switch='derived_merge=off';

select @@optimizer_switch;
select @@GLOBAL.optimizer_switch;

 5- Hit Enter two time.
6- Now Once again add Ado.net Entity Data Model and you will notice that your model will generate
successfully with the following tables in the database.

Remember. After running following code than Restart Visual Studio once again than add ado.net Entity data model to your project.


If Still same problem occur Please Comment below that i can help you.

Comments

  1. Unknown25 January 2018 at 12:58

    not working, only what work y change the collation on the field from my table. I dont know why vs dont like "utf8_general ci". Change that and done.

    ReplyDelete
    Replies
    1. Anonymous29 March 2018 at 01:49

      This comment has been removed by the author.

      Delete
    2. Anonymous29 March 2018 at 03:00

      To which collation you have changed from utf8_general ci

      Delete
  2. Unknown25 January 2018 at 12:59

    sry my english is so bad but i hope what you understande me.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Disable Skype on Windows Startup.

Image
Video Tutorial to Disable Skype Step by Step.      In this tutorial we will learn how to disable skype when  computer startup. To do this just follow my simple steps. 1- Click on Start button and search for "msconfig". 2- After Opening System configuration Click on startup button. 3- Now you can disable those software which is running during startup. 4- Click on checkbox to uncheck skype option. 5- After apply and ok they will ask to restart your computer and after restarting     you will notice skype will not start. Notice. Your computer will fast when you disable those software which is not necessary to  use when computer startup.  
Read more

How to Create mysql database Backup Using Command.

Image
In this tutorials we will learn that how to create my sql database backup using cmd. 1- First of all open cmd. 2- Go to C -> Program Files -> MySql -> MySQL Server 5.7 -> Bin. 3- Copy Bin Directory address like "C:\Program Files\MySQL\MySQL Server 5.7" . 4- Pasted in cmd like "cd C:\Program Files\MySQL\MySQL Server 5.7" hit Enter. 5- Now try to connect with mysqldump like C:\Program Files\MySQL\MySQL Server                      5.7>mysqldump -h localhost -u root -p databaseName. 6- Now Create New folder in C: Drive and rename it with "backup" name. 7- Copy that backup Folder Directory address like " C:\Program Files\MySQL\MySQL Server       5.7>mysqldump -h localhost -u root -p databaseName > C:\backup". 8- Finally at the end write a database name like " C:\Program Files\MySQL\MySQL Server    ...
Read more